GENERATED: JUL 10,2017 - 11:19PM
SQL Drill-Down Locator Examples [V10.17.05.0250]

Previous Page
In this application, we're illustrating some new SQL "drill-down" capabilities build into the locators available for ExplorerBrowse, LocatorOverRideControl and HandyMarkerBrowse. When any of these locators is configured to act as a filtering locator you have the option of asking the template to remember the last locator query and to re-apply it with your next locator query. The more locates performed before the locator clear button is clicked, the deeper you drill down into the current data set.

A new feature on the HandyMarkerBrowseProcessButton and HandyMarkerBrowesReportButton templates lets you opt to have the marked record set translated into an SQL IN(x,y,z) request to be sent to a report or process rather than a queue of marked records. Default behavior is as before, to send a queue.

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. You do not need a copy of the Microsoft Access to test this, and a copy of NORTHWIND.MDB is included in the install. The application will find the data base and register it with ODBC if not already registered.

Cheers,
Gus M. Creces
The Clarion Handy Tools Page
www.cwhandy.ca (CHT Website)
news.cwhandy.ca (CHT Forum)

 
PROCEDURE (1):
JumpStartHTTPRunHelpMediaWithAnimation (Procedure Template: Source)
Count Instance Class Type Methods Header File
(0001) ANI HNDAnimate HND 57 HNDANIMA.INC
(0002) HTTP HNDHttp HNDINET 219 HNDHTTP.INC
(0003) Win HNDWindow HND 214 HNDWINDO.INC
(3) Class Instances Found In JumpStartHTTPRunHelpMediaWithAnimation


 
PROCEDURE (2):
Main (Procedure Template: Frame)
Count Instance Class Type Methods Header File
(0001) HDisk HNDDisk HND 369 HNDDISK.INC
(0002) HReg HNDRegistry HND 310 HNDREG.INC
(0003) HWin HNDWindow HND 214 HNDWINDO.INC
(0004) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0005) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(5) Class Instances Found In Main


 
PROCEDURE (3):
JumpStartSplashCHTBlue (Procedure Template: Splash)
Count Instance Class Type Methods Header File
(0001) HTellMe HNDWindow HND 214 HNDWINDO.INC
(0002) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0003) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(3) Class Instances Found In JumpStartSplashCHTBlue


 
PROCEDURE (4):
SQLDrillDown_LocatorOverRideControl (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 46 ABBROWSE.INC
(0003) HBrw5 HNDBrowse HND 431 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) HWin4 HNDWindow HND 214 HNDWINDO.INC
(0006) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0007) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0008) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0009) BRW1::Sort3:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) BRW1::Sort4:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0012) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(12) Class Instances Found In SQLDrillDown_LocatorOverRideControl


 
PROCEDURE (5):
SQLDrillDown_HandyMarkerBrowse (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 46 ABBROWSE.INC
(0003) HMrkBrw5 HNDMarkerBrowse HND 476 HNDMRKBR.INC
(0004) HWin4 HNDWindow HND 214 HNDWINDO.INC
(0005) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0006) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0007) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0008) BRW1::Sort3:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0009) BRW1::Sort4:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0011) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(11) Class Instances Found In SQLDrillDown_HandyMarkerBrowse


 
PROCEDURE (6):
SQLQueryToHTMLCustomerProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) Qry2 HNDBrwFilter HND 320 HNDBRWFL.INC
(0002) Dos2 HNDExport HND 73 HNDEXPOR.INC
(0003) HTellMe6 HNDWindow HND 214 HNDWINDO.INC
(0004) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0005) ThisWindow ReportManager ABC 55 ABREPORT.INC
(0006) ProgressMgr StepStringClass ABC 8 ABBROWSE.INC
(6) Class Instances Found In SQLQueryToHTMLCustomerProcess


 
PROCEDURE (7):
SQLDrillDown_ExplorerBrowse (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 46 ABBROWSE.INC
(0003) HBrw5 HNDBrowse HND 431 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) HWin11 HNDWindow HND 214 HNDWINDO.INC
(0006) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0007) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0008) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0009) BRW1::Sort3:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) BRW1::Sort4:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0012) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(12) Class Instances Found In SQLDrillDown_ExplorerBrowse


 
PROCEDURE (8):
SQLQueryDirectToOrdersReport (Procedure Template: Report)
Count Instance Class Type Methods Header File
(0001) BreakMgr BreakManagerClass ABC 20 ABBREAK.INC
(0002) HQry3 HNDBrwFilter HND 320 HNDBRWFL.INC
(0003) HTellMe5 HNDWindow HND 214 HNDWINDO.INC
(0004) Previewer PrintPreviewClass ABC 58 ABREPORT.INC
(0005) ThisReport ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 55 ABREPORT.INC
(0007) TargetSelector ReportTargetSelectorClass ABC 25 ABRPPSEL.INC
(0008) ProgressMgr StepStringClass ABC 8 ABBROWSE.INC
(8) Class Instances Found In SQLQueryDirectToOrdersReport


 
PROCEDURE (9):
UpdateFormWithSQLBrowse (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW6 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW8 BrowseClass ABC 85 ABBROWSE.INC
(0003) HBrw7 HNDBrowse HND 431 HNDBROWS.INC
(0004) HBrw9 HNDBrowse HND 431 HNDBROWS.INC
(0005) HSizes7 HNDSizes HND 23 HNDSIZES.INC
(0006) HSizes9 HNDSizes HND 23 HNDSIZES.INC
(0007) HWin10 HNDWindow HND 214 HNDWINDO.INC
(0008) BRW6::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0009) BRW8::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0011) ToolbarForm ToolbarUpdateClass ABC 4 ABTOOLBA.INC
(0012) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(12) Class Instances Found In UpdateFormWithSQLBrowse


Copyright © 1996-2017
Gus M. Creces and The Clarion Handy Tools Page.
All Rights Reserved Worldwide

chtlogo001.gif Classes By Procedure In HNDDRLDN.APP