This application demonstrates CHT ListBoxBrowseExtender used in an SQL setting. An ordinary Clarion list box is used to build a ABC-style browse resembling HandyMarkerBrowse. It illustrates these concepts: • • • An LBX browse with UniversalQueryControl_LBX • • • An LBX browse with InQueueQueryControl_LBX • • • Connecting an update form with UpdateButtons_LBX • • • PROCEDURE: LBXWithUniversalQueryControl() The browse queue is loaded without pre-filter initially from the data table. The query control provides for entry of CHT queries which will re-fill the "Main" queue with a new subset of data directly from the data table while "Main Queue Data" is displayed. Click over to the "Shadow Queue Data" and CHT queries in the query control will display subsets of the "Main" data queue without data table access being excercised. Clearing the Main Queue Data query control reloads the Main queue from the data table. • • • PROCEDURE: LBXWithInQueueQueryTemplate() The browse queue is loaded without pre-filter initially from the data table. The query control provides for entry of a CHT query string. Records matching the query string are inserted into the "Shadow" queue which is then displayed. "Main" queue records remain undisturbed. Clearing the query empties the shadow queue and re-displays the Main queue. No file access is required after the initial data load from the data tables. A reset from file button, reloads the main queue from the data tables. 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. |
PROCEDURE (1): LBXWith_BUILT_IN_LocatorOnly (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | LBXX | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles5 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin11 | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In LBXWith_BUILT_IN_LocatorOnly | |||||
PROCEDURE (2): JumpStartSplashCHTBlue (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 JumpStartSplashCHTBlue | |||||
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): LBXWith_IN_QUEUE_QueryTemplate (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | LBXX | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles5 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin11 | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In LBXWith_IN_QUEUE_QueryTemplate | |||||
PROCEDURE (5): LBXWith_UNIVERSAL_QUERY_Control (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | LBX1 | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles5 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin11 | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In LBXWith_UNIVERSAL_QUERY_Control | |||||
PROCEDURE (6): CHTQueryToReport (Procedure Template: Report) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | BreakMgr | BreakManagerClass | ABC | 20 | ABBREAK.INC |
(0002) | HQry3 | HNDBrwFilter | HND | 321 | HNDBRWFL.INC |
(0003) | HTellMe5 | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0005) | Previewer | PrintPreviewClass | ABC | 59 | ABREPORT.INC |
(0006) | ThisReport | ProcessClass | ABC | 39 | ABREPORT.INC |
(0007) | ThisWindow | ReportManager | ABC | 56 | ABREPORT.INC |
(0008) | TargetSelector | ReportTargetSelectorClass | ABC | 25 | ABRPPSEL.INC |
(0009) | ProgressMgr | StepClass | ABC | 6 | ABBROWSE.INC |
(9) Class Instances Found In CHTQueryToReport | |||||
PROCEDURE (7): MainEntryPoint (Procedure Template: Frame) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | HReg | HNDRegistry | HND | 336 | HNDREG.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 MainEntryPoint | |||||