GENERATED: MAY 4,2023 - 8:53AM
BROWSES MIXED (SQL) [V10.23.04. 27.00]

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 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


 
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 47 ABBROWSE.INC
(0003) HBrw5 HNDBrowse HND 432 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles2 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin4 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 EXPB2_ExplorerBrowse


 
PROCEDURE (3):
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 (4):
RegisterODBC (Procedure Template: Source)
Count Instance Class Type Methods Header File
(0001) HDisk ADOBlob SV 4 SVADO.INC
(0002) HReg HNDRegistry HND 336 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 321 HNDBRWFL.INC
(0002) Dos2 HNDExport HND 73 HNDEXPOR.INC
(0003) HTellMe6 HNDWindow HND 206 HNDWINDO.INC
(0004) HWin HNDWindow HND 206 HNDWINDO.INC
(0005) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 56 ABREPORT.INC
(0007) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(7) 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 321 HNDBRWFL.INC
(0003) HQry6 HNDBrwFilter HND 321 HNDBRWFL.INC
(0004) HTellMe5 HNDWindow HND 206 HNDWINDO.INC
(0005) HWin HNDWindow HND 206 HNDWINDO.INC
(0006) Previewer PrintPreviewClass ABC 59 ABREPORT.INC
(0007) ThisReport ProcessClass ABC 39 ABREPORT.INC
(0008) ThisWindow ReportManager ABC 56 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 432 HNDBROWS.INC
(0004) HBrw8 HNDBrowse HND 432 HNDBROWS.INC
(0005) HSizes7 HNDSizes HND 23 HNDSIZES.INC
(0006) HSizes9 HNDSizes HND 23 HNDSIZES.INC
(0007) HWin10 HNDWindow HND 206 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 40 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 47 ABBROWSE.INC
(0003) HMrkBrw5 HNDMarkerBrowse HND 480 HNDMRKBR.INC
(0004) Handles10 HNDSizes HND 23 HNDSIZES.INC
(0005) HWin4 HNDWindow HND 206 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 40 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 47 ABBROWSE.INC
(0003) HBrw5 HNDBrowse HND 432 HNDBROWS.INC
(0004) HQry7 HNDBrwFilter HND 321 HNDBRWFL.INC
(0005) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0006) Handles10 HNDSizes HND 23 HNDSIZES.INC
(0007) HWin11 HNDWindow HND 206 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 40 ABWINDOW.INC
(14) Class Instances Found In EXPB5_ExplorerBrowse


 
PROCEDURE (10):
JumpStartHTTPRunHelpMediaWithAnimation (Procedure Template: Source)
Count Instance Class Type Methods Header File
(0001) ANI ADOBlob SV 4 SVADO.INC
(0002) HTTP ADOBlob SV 4 SVADO.INC
(0003) Win HNDWindow HND 206 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 206 HNDWINDO.INC
(0003) HWin HNDWindow HND 206 HNDWINDO.INC
(0004) Previewer PrintPreviewClass ABC 59 ABREPORT.INC
(0005) ThisReport ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 56 ABREPORT.INC
(0007) TargetSelector ReportTargetSelectorClass ABC 25 ABRPPSEL.INC
(0008) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(8) 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 47 ABBROWSE.INC
(0003) HMrkBrw5 HNDMarkerBrowse HND 480 HNDMRKBR.INC
(0004) Handles2 HNDSizes HND 23 HNDSIZES.INC
(0005) HWin4 HNDWindow HND 206 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 40 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 47 ABBROWSE.INC
(0003) HBRWS 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 EXPB3_ExplorerBrowse


 
PROCEDURE (14):
QPFC_ABCProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) HQry HNDBrwFilter HND 321 HNDBRWFL.INC
(0002) Handles2 HNDSizes HND 23 HNDSIZES.INC
(0003) HTellMe6 HNDWindow HND 206 HNDWINDO.INC
(0004) HWin HNDWindow HND 206 HNDWINDO.INC
(0005) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 56 ABREPORT.INC
(0007) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(7) 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 47 ABBROWSE.INC
(0003) HBrw5 HNDBrowse HND 432 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles6 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 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 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 StepLongClass ABC 6 ABBROWSE.INC
(9) 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 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) Handles15 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 ManagePreBuiltQueries


 
PROCEDURE (18):
SQLQueryToHTMLCustomerProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) Qry2 HNDBrwFilter HND 321 HNDBRWFL.INC
(0002) Dos2 HNDExport HND 73 HNDEXPOR.INC
(0003) HTellMe6 HNDWindow HND 206 HNDWINDO.INC
(0004) HWin HNDWindow HND 206 HNDWINDO.INC
(0005) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 56 ABREPORT.INC
(0007) ProgressMgr StepStringClass ABC 8 ABBROWSE.INC
(7) 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 47 ABBROWSE.INC
(0003) QPFC HNDBrwFilter HND 321 HNDBRWFL.INC
(0004) Handles7 HNDSizes HND 23 HNDSIZES.INC
(0005) HWin11 HNDWindow HND 206 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 40 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 47 ABBROWSE.INC
(0003) HBrw5 HNDBrowse HND 432 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles2 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin4 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 EXPB1_ExplorerBrowse


Copyright © 1996-2023
Gus M. Creces, CLARION HANDY TOOLS
All Rights Reserved Worldwide

chtlogo001.gif
Classes By Procedure