|
This application demonstrates CHT Explorerbrowse used in an SQL setting with a new locator template called ExplorerBrowseLocatorControlEx. It illustrates these concepts: • • • Display data only when the filtering locator has an entry. • • • Locator drill-down "breadcrumb" trail. • • • Display either CHT query language or SQL. • • • Execute Locator with tab or with GO button. • • • SQLSelect example of filling browse queue with user SELECT. • • • EmbedViewEx filling browse queue with in-line process. This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. 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): SQLQueryDirectToOrdersReport (Procedure Template: Report) |
|||||
| Count | Instance | Class | Type | Methods | Header File |
| (0001) | BreakMgr | BreakManagerClass | ABC | 20 | ABBREAK.INC |
| (0002) | HQry3 | HNDBrwFilter | HND | 245 | HNDBRWFL.INC |
| (0003) | HTellMe5 | HNDWindow | HND | 197 | HNDWINDO.INC |
| (0004) | Previewer | PrintPreviewClass | ABC | 53 | ABREPORT.INC |
| (0005) | ThisReport | ProcessClass | ABC | 39 | ABREPORT.INC |
| (0006) | ThisWindow | ReportManager | ABC | 49 | ABREPORT.INC |
| (0007) | TargetSelector | ReportTargetSelectorClass | ABC | 11 | ABRPPSEL.INC |
| (0008) | ProgressMgr | StepClass | ABC | 6 | ABBROWSE.INC |
| (8) Class Instances Found In SQLQueryDirectToOrdersReport | |||||
| PROCEDURE (2): ExplorerBrowseWithExtendedLocator (Procedure Template: Window) |
|||||
| Count | Instance | Class | Type | Methods | Header File |
| (0001) | BRW1 | BrowseClass | ABC | 82 | ABBROWSE.INC |
| (0002) | BRW1::EIPManager | BrowseEIPManager | ABC | 45 | ABBROWSE.INC |
| (0003) | HBrw5 | HNDBrowse | HND | 354 | HNDBROWS.INC |
| (0004) | HSizes5 | HNDSizes | HND | 23 | HNDSIZES.INC |
| (0005) | HView7 | HNDViewAdapter | HND | 50 | HNDVWDAP.INC |
| (0006) | HWin11 | HNDWindow | HND | 197 | HNDWINDO.INC |
| (0007) | BRW1::Sort0:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
| (0008) | BRW1::Sort1:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
| (0009) | BRW1::Sort2:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
| (0010) | BRW1::Sort3:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
| (0011) | BRW1::Sort4:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
| (0012) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
| (0013) | ThisWindow | WindowManager | ABC | 38 | ABWINDOW.INC |
| (13) Class Instances Found In ExplorerBrowseWithExtendedLocator | |||||
| PROCEDURE (3): IniTableIOProcedure (Procedure Template: IniTableIOProcedure) |
|||||
| Count | Instance | Class | Type | Methods | Header File |
| (0001) | HSRC | HNDSourceProcedure | HND | 46 | HNDSRC.INC |
| (1) Class Instances Found In IniTableIOProcedure | |||||
| PROCEDURE (4): CompanyUpdateForm (Procedure Template: Window) |
|||||
| Count | Instance | Class | Type | Methods | Header File |
| (0001) | HWin10 | HNDWindow | HND | 197 | HNDWINDO.INC |
| (0002) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
| (0003) | ToolbarForm | ToolbarUpdateClass | ABC | 4 | ABTOOLBA.INC |
| (0004) | ThisWindow | WindowManager | ABC | 38 | ABWINDOW.INC |
| (4) Class Instances Found In CompanyUpdateForm | |||||
| PROCEDURE (5): JumpStartSplashCHTBlue (Procedure Template: Splash) |
|||||
| Count | Instance | Class | Type | Methods | Header File |
| (0001) | HTellMe | HNDWindow | HND | 197 | HNDWINDO.INC |
| (0002) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
| (0003) | ThisWindow | WindowManager | ABC | 38 | ABWINDOW.INC |
| (3) Class Instances Found In JumpStartSplashCHTBlue | |||||
| PROCEDURE (6): RegisterODBC (Procedure Template: Source) |
|||||
| Count | Instance | Class | Type | Methods | Header File |
| (0001) | HDisk | HNDDisk | HNDDISK | 333 | HNDDISK.INC |
| (0002) | HReg | HNDRegistry | HND | 276 | HNDREG.INC |
| (2) Class Instances Found In RegisterODBC | |||||
| PROCEDURE (7): MainEntryPoint (Procedure Template: Frame) |
|||||
| Count | Instance | Class | Type | Methods | Header File |
| (0001) | HDisk | HNDDisk | HNDDISK | 333 | HNDDISK.INC |
| (0002) | HReg | HNDRegistry | HND | 276 | HNDREG.INC |
| (0003) | HWin | HNDWindow | HND | 197 | HNDWINDO.INC |
| (0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
| (0005) | ThisWindow | WindowManager | ABC | 38 | ABWINDOW.INC |
| (5) Class Instances Found In MainEntryPoint | |||||
Classes By Procedure In HNDSQL7.APP