GENERATED: SEP 5,2019 - 4:16PM
BROWSES MIXED (SQL) [V10.19.09]

Previous Page

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

The CHT template QueryParsingFilterControl (QPFC) has the ability to generate optimised NATIVE SQL directly from your real-language CHT queries.

The SQL is then sent to your data base using View{PROP:SQLFilter} rather than via ABC.SetFilter(). We've also added an optional QUERY BUILDER (OBJ.QBInterface()) to the ? button of the QueryParsingFilterControl (QPFC) template.

The CHT-generated SQL appears in the WHERE clause component of the SELECT string sent to your data base. The chief advantage of this is speed. Clarion's file drivers do not always translate clarion filter strings into effective SQL. In some cases, depending how complex your query, ABC.Setfilter() causes the driver to literally read large portions of the data base, forcing the driver to manage filtering rather than letting the data base handle it.

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


 
PROCEDURE (2):
ExplorerBrowseLocatorControlOnly (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 432 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 ExplorerBrowseLocatorControlOnly


 
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 381 HNDDISK.INC
(0002) HReg HNDRegistry HND 315 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 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 321 HNDBRWFL.INC
(0003) HQry6 HNDBrwFilter HND 321 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 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 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):
QPFC_ABCProcess_HandyQueryProcessLimiter (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) HQry HNDBrwFilter HND 321 HNDBRWFL.INC
(0002) HTellMe HNDWindow HND 215 HNDWINDO.INC
(0003) HWin 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_HandyQueryProcessLimiter


 
PROCEDURE (9):
SQLFilter_HMB_OneColumnLocator (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 481 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 SQLFilter_HMB_OneColumnLocator


 
PROCEDURE (10):
SQLFilter_ExplorerBrowse_QPFC (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 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 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 SQLFilter_ExplorerBrowse_QPFC


 
PROCEDURE (11):
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 (12):
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 (13):
SQLFilter_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 481 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 SQLFilter_HandyMarkerBrowse


 
PROCEDURE (14):
SQLFilter_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 432 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 SQLFilter_ExplorerBrowse


 
PROCEDURE (15):
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 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 (16):
SQLFilter_EXPB_OneColumnLocator (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 432 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 SQLFilter_EXPB_OneColumnLocator


 
PROCEDURE (17):
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 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 (18):
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 432 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 (19):
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 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 (20):
QueryParser_ABCBrowse (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) HQry5 HNDBrwFilter HND 321 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 QueryParser_ABCBrowse


 
PROCEDURE (21):
ExplorerBrowseLocatorControlEx (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 432 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 ExplorerBrowseLocatorControlEx


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

chtlogo001.gif Classes By Procedure In HNDACCES.APP