GENERATED: JUL 19,2019 - 1:06PM
BROWSES LBX (SQL) [V10.19.07]

Previous Page
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 449 HNDFLBRW.INC
(0002) Handles5 HNDSizes HND 23 HNDSIZES.INC
(0003) HWin11 HNDWindow HND 215 HNDWINDO.INC
(0004) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0005) ThisWindow WindowManager ABC 39 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 215 HNDWINDO.INC
(0002) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0003) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(3) Class Instances Found In JumpStartSplashCHTBlue


 
PROCEDURE (3):
CompanyUpdateForm (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) HWin10 HNDWindow HND 215 HNDWINDO.INC
(0002) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0003) ToolbarForm ToolbarUpdateClass ABC 4 ABTOOLBA.INC
(0004) ThisWindow WindowManager ABC 39 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 449 HNDFLBRW.INC
(0002) Handles5 HNDSizes HND 23 HNDSIZES.INC
(0003) HWin11 HNDWindow HND 215 HNDWINDO.INC
(0004) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0005) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(5) Class Instances Found In LBXWith_IN_QUEUE_QueryTemplate


 
PROCEDURE (5):
RegisterODBC (Procedure Template: Source)
Count Instance Class Type Methods Header File
(0001) HDisk HNDDisk HND 381 HNDDISK.INC
(0002) HReg HNDRegistry HND 315 HNDREG.INC
(2) Class Instances Found In RegisterODBC


 
PROCEDURE (6):
LBXWith_UNIVERSAL_QUERY_Control (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) LBX1 HNDFileLoadBrowse HND 449 HNDFLBRW.INC
(0002) Handles5 HNDSizes HND 23 HNDSIZES.INC
(0003) HWin11 HNDWindow HND 215 HNDWINDO.INC
(0004) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0005) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(5) Class Instances Found In LBXWith_UNIVERSAL_QUERY_Control


 
PROCEDURE (7):
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 215 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 StepClass ABC 6 ABBROWSE.INC
(8) Class Instances Found In CHTQueryToReport


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


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

chtlogo001.gif Classes By Procedure In HNDLBXSQLEX.APP