GENERATED: MAR 29,2020 - 1:27PM
BROWSES MIXED (SQL) [V10.20.03]

Previous Page
This application demonstrates the added speed and convenience of the NATIVE SQL filtering capability built into the CHT query classes.

The following listing names and provides a summary of the illustative procedures provided with this application:

• •  ABCBRW_ABCBrowseOnly • •  - Procedure illustrates ABC browse only with no CHT browse extensions, PLUS Query Parsing Filter Control (QPFC).

• •  EXPB1_ExplorerBrowse • •  - Procedure uses ExplorerBrowse with Explorer Browse Locator ControlEx template.

• •  EXPB2_ExplorerBrowse • •  - Procedure uses ExplorerBrowse with Explorer Browse Locator Control template.

• •  EXPB3_ExplorerBrowse • •  - Procedure uses Explorerbrowse with built-in filtering locator enabled.

• •  EXPB4_ExplorerBrowse • •  - Procedure uses Explorerbrowse with serveral ExplorerBrowse One Column Query Control templates populated on the window.

• •  EXPB5_ExplorerBrowse • •  - Procedure uses Explorerbrowse with Query Parsing Filter Control template.

• •  HMB1_HandyMarkerBrowse • •  - Procedure uses HandyMarkerBrowse with built in filtering locator enabled.

• •  HMB2_HandyMarkerBrowse • •  - Procedure uses HandyMarkerBrowse with serveral Handy Marker Browse One Column Query Control templates populated on the window.

All procedures in this application are SQL-Trace enabled, allowing you, with HNDSQLTRACE.EXE to trace all back-end SQL calls from the application to 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):
MainEntryPoint (Procedure Template: Frame)
Count Instance Class Type Methods Header File
(0001) HDisk HNDDisk HND 382 HNDDISK.INC
(0002) HReg HNDRegistry HND 317 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


 
PROCEDURE (2):
EXPB2_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 434 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles2 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin4 HNDWindow HND 215 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 39 ABWINDOW.INC
(13) Class Instances Found In EXPB2_ExplorerBrowse


 
PROCEDURE (3):
JumpStartSplash06 (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 JumpStartSplash06


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


 
PROCEDURE (5):
CHTQueryToHTMLCustomerProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) Qry2 HNDBrwFilter HND 322 HNDBRWFL.INC
(0002) Dos2 HNDExport HND 73 HNDEXPOR.INC
(0003) HTellMe6 HNDWindow HND 215 HNDWINDO.INC
(0004) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0005) ThisWindow ReportManager ABC 55 ABREPORT.INC
(0006) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(6) Class Instances Found In CHTQueryToHTMLCustomerProcess


 
PROCEDURE (6):
QPFC_ABCReport_HandyQueryReportLimiter (Procedure Template: Report)
Count Instance Class Type Methods Header File
(0001) BreakMgr BreakManagerClass ABC 20 ABBREAK.INC
(0002) HQry2 HNDBrwFilter HND 322 HNDBRWFL.INC
(0003) HQry6 HNDBrwFilter HND 322 HNDBRWFL.INC
(0004) HTellMe5 HNDWindow HND 215 HNDWINDO.INC
(0005) HWin HNDWindow HND 215 HNDWINDO.INC
(0006) Previewer PrintPreviewClass ABC 58 ABREPORT.INC
(0007) ThisReport ProcessClass ABC 39 ABREPORT.INC
(0008) ThisWindow ReportManager ABC 55 ABREPORT.INC
(0009) TargetSelector ReportTargetSelectorClass ABC 25 ABRPPSEL.INC
(0010) ProgressMgr StepLongClass ABC 6 ABBROWSE.INC
(10) Class Instances Found In QPFC_ABCReport_HandyQueryReportLimiter


 
PROCEDURE (7):
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) HBrw6 HNDBrowse HND 434 HNDBROWS.INC
(0004) HBrw8 HNDBrowse HND 434 HNDBROWS.INC
(0005) HSizes7 HNDSizes HND 23 HNDSIZES.INC
(0006) HSizes9 HNDSizes HND 23 HNDSIZES.INC
(0007) HWin10 HNDWindow HND 215 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


 
PROCEDURE (8):
HMB2_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 482 HNDMRKBR.INC
(0004) Handles10 HNDSizes HND 23 HNDSIZES.INC
(0005) HWin4 HNDWindow HND 215 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 HMB2_HandyMarkerBrowse


 
PROCEDURE (9):
EXPB5_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 434 HNDBROWS.INC
(0004) HQry7 HNDBrwFilter HND 322 HNDBRWFL.INC
(0005) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0006) Handles10 HNDSizes HND 23 HNDSIZES.INC
(0007) HWin11 HNDWindow HND 215 HNDWINDO.INC
(0008) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0009) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) BRW1::Sort3:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0012) BRW1::Sort4:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0013) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0014) ThisWindow WindowManager ABC 39 ABWINDOW.INC
(14) Class Instances Found In EXPB5_ExplorerBrowse


 
PROCEDURE (10):
JumpStartHTTPRunHelpMediaWithAnimation (Procedure Template: Source)
Count Instance Class Type Methods Header File
(0001) ANI HNDAnimate HND 57 HNDANIMA.INC
(0002) HTTP HNDHttp HNDINET 224 HNDHTTP.INC
(0003) Win HNDWindow HND 215 HNDWINDO.INC
(3) Class Instances Found In JumpStartHTTPRunHelpMediaWithAnimation


 
PROCEDURE (11):
MarkerBrowseDirectToCustomerReport (Procedure Template: Report)
Count Instance Class Type Methods Header File
(0001) BreakMgr BreakManagerClass ABC 20 ABBREAK.INC
(0002) HTellMe5 HNDWindow HND 215 HNDWINDO.INC
(0003) Previewer PrintPreviewClass ABC 58 ABREPORT.INC
(0004) ThisReport ProcessClass ABC 39 ABREPORT.INC
(0005) ThisWindow ReportManager ABC 55 ABREPORT.INC
(0006) TargetSelector ReportTargetSelectorClass ABC 25 ABRPPSEL.INC
(0007) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(7) Class Instances Found In MarkerBrowseDirectToCustomerReport


 
PROCEDURE (12):
HMB1_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 482 HNDMRKBR.INC
(0004) Handles2 HNDSizes HND 23 HNDSIZES.INC
(0005) HWin4 HNDWindow HND 215 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 HMB1_HandyMarkerBrowse


 
PROCEDURE (13):
EXPB3_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) HBRWS HNDBrowse HND 434 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles7 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin11 HNDWindow HND 215 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 39 ABWINDOW.INC
(13) Class Instances Found In EXPB3_ExplorerBrowse


 
PROCEDURE (14):
QPFC_ABCProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) HQry HNDBrwFilter HND 322 HNDBRWFL.INC
(0002) Handles2 HNDSizes HND 23 HNDSIZES.INC
(0003) HTellMe6 HNDWindow HND 215 HNDWINDO.INC
(0004) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0005) ThisWindow ReportManager ABC 55 ABREPORT.INC
(0006) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(6) Class Instances Found In QPFC_ABCProcess


 
PROCEDURE (15):
EXPB4_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 434 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles6 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin11 HNDWindow HND 215 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 39 ABWINDOW.INC
(13) Class Instances Found In EXPB4_ExplorerBrowse


 
PROCEDURE (16):
QPFC_ABCReport (Procedure Template: Report)
Count Instance Class Type Methods Header File
(0001) BreakMgr BreakManagerClass ABC 20 ABBREAK.INC
(0002) HQry2 HNDBrwFilter HND 322 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 StepLongClass ABC 6 ABBROWSE.INC
(8) Class Instances Found In QPFC_ABCReport


 
PROCEDURE (17):
ManagePreBuiltQueries (Procedure Template: Browse)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 85 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 46 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 434 HNDBROWS.INC
(0007) HSizes6 HNDSizes HND 23 HNDSIZES.INC
(0008) Handles15 HNDSizes HND 23 HNDSIZES.INC
(0009) HWin HNDWindow HND 215 HNDWINDO.INC
(0010) BRW1::Sort0: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 ManagePreBuiltQueries


 
PROCEDURE (18):
SQLQueryToHTMLCustomerProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) Qry2 HNDBrwFilter HND 322 HNDBRWFL.INC
(0002) Dos2 HNDExport HND 73 HNDEXPOR.INC
(0003) HTellMe6 HNDWindow HND 215 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 (19):
ABCBrowseQPFC (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) QPFC HNDBrwFilter HND 322 HNDBRWFL.INC
(0004) Handles7 HNDSizes HND 23 HNDSIZES.INC
(0005) HWin11 HNDWindow HND 215 HNDWINDO.INC
(0006) BRW1::Sort0:StepClass StepClass ABC 6 ABBROWSE.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 39 ABWINDOW.INC
(13) Class Instances Found In ABCBrowseQPFC


 
PROCEDURE (20):
EXPB1_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 434 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles2 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin4 HNDWindow HND 215 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 39 ABWINDOW.INC
(13) Class Instances Found In EXPB1_ExplorerBrowse


Copyright © 1996-2020
Gus M. Creces, CHT - Clarion Handy Tools
All Rights Reserved Worldwide

chtlogo001.gif
Classes By Procedure