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 | |||||