This application demonstrates CHT Explorerbrowse used in an SQL setting in conjunction with query template PopFavoriteQueries_EXPB (PFQ_EXPB) It illustrates these concepts: • • • An Explorerbrowse implementation running on SQL Data Tables. • • • CHT Query template PopFavoriteQueries_EXPB • • • Default query applied on browse opening is under user, run-time control • • • Concatentaion of two fields (TELEPHONE + FAX) in a single column • • • TELEPHONE and FAX are individually queryable from PFQ_EXPB • • • SetExplorerBrowseQueryBindings - enables querying of fields not individually displayed in the browse. for example: FAX This demonstration application requires the sample data tables provided with MICROSOFT ACCESS, called Northwind. The CHT toolkit installs these Northwind tables for you. The application finds these tables and registers them with ODBC if not already registered when you first run this demo app. |
PROCEDURE (1): JumpStartManagePreBuiltQueriesSQL (Procedure Template: Browse) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | BRW1 | BrowseClass | ABC | 85 | ABBROWSE.INC |
(0002) | BRW1::EIPManager | BrowseEIPManager | ABC | 47 | ABBROWSE.INC |
(0003) | EditInPlace::PRQ:Description | EditEntryClass | ABC | 9 | ABEIP.INC |
(0004) | EditInPlace::PRQ:ViewName | EditEntryClass | ABC | 9 | ABEIP.INC |
(0005) | EditInPlace::PRQ:ViewQuery | EditEntryClass | ABC | 9 | ABEIP.INC |
(0006) | HBrw6 | HNDBrowse | HND | 432 | HNDBROWS.INC |
(0007) | HSizes6 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0008) | Handles7 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0009) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0010) | BRW1::Sort0:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0011) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0012) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(12) Class Instances Found In JumpStartManagePreBuiltQueriesSQL | |||||
PROCEDURE (2): JumpStartSplash06 (Procedure Template: Splash) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | HTellMe | HNDWindow | HND | 206 | HNDWINDO.INC |
(0002) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0003) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0004) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(4) Class Instances Found In JumpStartSplash06 | |||||
PROCEDURE (3): CompanyUpdateForm (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | HWin10 | HNDWindow | HND | 206 | HNDWINDO.INC |
(0002) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0003) | ToolbarForm | ToolbarUpdateClass | ABC | 4 | ABTOOLBA.INC |
(0004) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(4) Class Instances Found In CompanyUpdateForm | |||||
PROCEDURE (4): ExplorerBrowseWithPopFavoriteQueries_EXPB (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | BRW1 | BrowseClass | ABC | 85 | ABBROWSE.INC |
(0002) | BRW1::EIPManager | BrowseEIPManager | ABC | 47 | ABBROWSE.INC |
(0003) | HBrw5 | HNDBrowse | HND | 432 | HNDBROWS.INC |
(0004) | HSizes5 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0005) | Handles7 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0006) | HWin11 | HNDWindow | HND | 206 | 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 | 40 | ABWINDOW.INC |
(13) Class Instances Found In ExplorerBrowseWithPopFavoriteQueries_EXPB | |||||
PROCEDURE (5): MainEntryPoint (Procedure Template: Frame) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | HDisk | HNDDisk | HND | 401 | HNDDISK.INC |
(0002) | HReg | HNDRegistry | HND | 336 | HNDREG.INC |
(0003) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In MainEntryPoint | |||||