GENERATED: MAR 31,2012 - 4:01PM
CHT SQL Demonstration [V8.01.00]

Previous Page
This application demonstrates the added speed and convenience of the NATIVE SQL filtering capability built into the CHT query parser classes. Make sure to check the tutorial available with this application for more information about what this demonstration application illustrates about The Clarion Handy Tools.

The CHT query parser has the ability to generate optimised NATIVE SQL directly from your real-language queries. The SQL is then sent to your data base using View{PROP:SQLFilter} rather than via ABC.SetFilter(). In the O8A1.0 build we've added an optional QUERY BUILDER (OBJ.QBInterface()) to the ? button of the QueryParsingFilterControl 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.

Cheers,
Gus M. Creces
The Clarion Handy Tools Page
www.cwhandy.ca (CHT Website)
news.cwhandy.ca (CHT Forum)

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


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


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


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


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


 
PROCEDURE (6):
UpdateFormWithSQLBrowse (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW6 BrowseClass ABC 82 ABBROWSE.INC
(0002) BRW8 BrowseClass ABC 82 ABBROWSE.INC
(0003) HBrw7 HNDBrowse HND 354 HNDBROWS.INC
(0004) HBrw9 HNDBrowse HND 354 HNDBROWS.INC
(0005) HSizes7 HNDSizes HND 23 HNDSIZES.INC
(0006) HSizes9 HNDSizes HND 23 HNDSIZES.INC
(0007) HWin10 HNDWindow HND 197 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 38 ABWINDOW.INC
(12) Class Instances Found In UpdateFormWithSQLBrowse


 
PROCEDURE (7):
IniTableIOProcedure (Procedure Template: IniTableIOProcedure)
Count Instance Class Type Methods Header File
(0001) HSRC HNDSourceProcedure HND 46 HNDSRC.INC
(1) Class Instances Found In IniTableIOProcedure


 
PROCEDURE (8):
QPFC_ABCProcess_HandyQueryProcessLimiter (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) HQry HNDBrwFilter HND 245 HNDBRWFL.INC
(0002) Dos2 HNDExport HND 75 HNDEXPOR.INC
(0003) HTellMe HNDWindow HND 197 HNDWINDO.INC
(0004) HWin HNDWindow HND 197 HNDWINDO.INC
(0005) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0007) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(7) Class Instances Found In QPFC_ABCProcess_HandyQueryProcessLimiter


 
PROCEDURE (9):
JumpStartSplashCHTBlue (Procedure Template: Splash)
Count Instance Class Type Methods Header File
(0001) HTellMe HNDWindow HND 197 HNDWINDO.INC
(0002) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0003) ThisWindow WindowManager ABC 38 ABWINDOW.INC
(3) Class Instances Found In JumpStartSplashCHTBlue


 
PROCEDURE (10):
ClarionQueryDirectToOrdersReport (Procedure Template: Report)
Count Instance Class Type Methods Header File
(0001) BreakMgr BreakManagerClass ABC 20 ABBREAK.INC
(0002) HQry3 HNDBrwFilter HND 245 HNDBRWFL.INC
(0003) HTellMe5 HNDWindow HND 197 HNDWINDO.INC
(0004) Previewer PrintPreviewClass ABC 53 ABREPORT.INC
(0005) ThisReport ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0007) TargetSelector ReportTargetSelectorClass ABC 11 ABRPPSEL.INC
(0008) ProgressMgr StepLongClass ABC 6 ABBROWSE.INC
(8) Class Instances Found In ClarionQueryDirectToOrdersReport


 
PROCEDURE (11):
CHTQueryDirectToOrdersReport (Procedure Template: Report)
Count Instance Class Type Methods Header File
(0001) BreakMgr BreakManagerClass ABC 20 ABBREAK.INC
(0002) HQry3 HNDBrwFilter HND 245 HNDBRWFL.INC
(0003) HTellMe5 HNDWindow HND 197 HNDWINDO.INC
(0004) Previewer PrintPreviewClass ABC 53 ABREPORT.INC
(0005) ThisReport ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0007) TargetSelector ReportTargetSelectorClass ABC 11 ABRPPSEL.INC
(0008) ProgressMgr StepLongClass ABC 6 ABBROWSE.INC
(8) Class Instances Found In CHTQueryDirectToOrdersReport


 
PROCEDURE (12):
MarkerBrowseToHTMLOrdersProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) DOS2 HNDExport HND 75 HNDEXPOR.INC
(0002) HTellMe6 HNDWindow HND 197 HNDWINDO.INC
(0003) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0004) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0005) ProgressMgr StepStringClass ABC 8 ABBROWSE.INC
(5) Class Instances Found In MarkerBrowseToHTMLOrdersProcess


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


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


 
PROCEDURE (15):
SQLFilter_HandyMarkerBrowse (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 82 ABBROWSE.INC
(0002) BRW7 BrowseClass ABC 82 ABBROWSE.INC
(0003) BRW1::EIPManager BrowseEIPManager ABC 45 ABBROWSE.INC
(0004) HQry9 HNDBrwFilter HND 245 HNDBRWFL.INC
(0005) HMrkBrw5 HNDMarkerBrowse HND 372 HNDMRKBR.INC
(0006) HMrkBrw8 HNDMarkerBrowse HND 372 HNDMRKBR.INC
(0007) HWin4 HNDWindow HND 197 HNDWINDO.INC
(0008) VisitMe2 HNDWindow HND 197 HNDWINDO.INC
(0009) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0010) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0012) BRW1::Sort3:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0013) BRW1::Sort4:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0014) BRW7::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0015) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0016) ThisWindow WindowManager ABC 38 ABWINDOW.INC
(16) Class Instances Found In SQLFilter_HandyMarkerBrowse


 
PROCEDURE (16):
SQLFilter_ExplorerBrowse (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 82 ABBROWSE.INC
(0002) BRW7 BrowseClass ABC 82 ABBROWSE.INC
(0003) BRW1::EIPManager BrowseEIPManager ABC 45 ABBROWSE.INC
(0004) HBrw5 HNDBrowse HND 354 HNDBROWS.INC
(0005) HBrw8 HNDBrowse HND 354 HNDBROWS.INC
(0006) HQry9 HNDBrwFilter HND 245 HNDBRWFL.INC
(0007) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0008) HSizes8 HNDSizes HND 23 HNDSIZES.INC
(0009) HWin11 HNDWindow HND 197 HNDWINDO.INC
(0010) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0012) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0013) BRW1::Sort3:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0014) BRW1::Sort4:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0015) BRW7::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0016) BRW7::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0017) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0018) ThisWindow WindowManager ABC 38 ABWINDOW.INC
(18) Class Instances Found In SQLFilter_ExplorerBrowse


 
PROCEDURE (17):
ClarionQueryToHTMLCustomerProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) Qry2 HNDBrwFilter HND 245 HNDBRWFL.INC
(0002) Dos2 HNDExport HND 75 HNDEXPOR.INC
(0003) HTellMe6 HNDWindow HND 197 HNDWINDO.INC
(0004) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0005) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0006) ProgressMgr StepStringClass ABC 8 ABBROWSE.INC
(6) Class Instances Found In ClarionQueryToHTMLCustomerProcess


 
PROCEDURE (18):
QPFC_ABCProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) HQry HNDBrwFilter HND 245 HNDBRWFL.INC
(0002) HTellMe6 HNDWindow HND 197 HNDWINDO.INC
(0003) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0004) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0005) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(5) Class Instances Found In QPFC_ABCProcess


 
PROCEDURE (19):
QPFC_ABCReport (Procedure Template: Report)
Count Instance Class Type Methods Header File
(0001) BreakMgr BreakManagerClass ABC 20 ABBREAK.INC
(0002) HQry2 HNDBrwFilter HND 245 HNDBRWFL.INC
(0003) HTellMe5 HNDWindow HND 197 HNDWINDO.INC
(0004) Previewer PrintPreviewClass ABC 53 ABREPORT.INC
(0005) ThisReport ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0007) TargetSelector ReportTargetSelectorClass ABC 11 ABRPPSEL.INC
(0008) ProgressMgr StepLongClass ABC 6 ABBROWSE.INC
(8) Class Instances Found In QPFC_ABCReport


 
PROCEDURE (20):
MarkerBrowseToHTMLCustomerProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) DOS2 HNDExport HND 75 HNDEXPOR.INC
(0002) HTellMe6 HNDWindow HND 197 HNDWINDO.INC
(0003) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0004) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0005) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(5) Class Instances Found In MarkerBrowseToHTMLCustomerProcess


 
PROCEDURE (21):
SQLQueryToHTMLCustomerProcess (Procedure Template: Process)
Count Instance Class Type Methods Header File
(0001) Qry2 HNDBrwFilter HND 245 HNDBRWFL.INC
(0002) Dos2 HNDExport HND 75 HNDEXPOR.INC
(0003) HTellMe6 HNDWindow HND 197 HNDWINDO.INC
(0004) ThisProcess ProcessClass ABC 39 ABREPORT.INC
(0005) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0006) ProgressMgr StepStringClass ABC 8 ABBROWSE.INC
(6) Class Instances Found In SQLQueryToHTMLCustomerProcess


 
PROCEDURE (22):
SQLQueryDirectToOrdersReport (Procedure Template: Report)
Count Instance Class Type Methods Header File
(0001) BreakMgr BreakManagerClass ABC 20 ABBREAK.INC
(0002) HQry3 HNDBrwFilter HND 245 HNDBRWFL.INC
(0003) HTellMe5 HNDWindow HND 197 HNDWINDO.INC
(0004) Previewer PrintPreviewClass ABC 53 ABREPORT.INC
(0005) ThisReport ProcessClass ABC 39 ABREPORT.INC
(0006) ThisWindow ReportManager ABC 49 ABREPORT.INC
(0007) TargetSelector ReportTargetSelectorClass ABC 11 ABRPPSEL.INC
(0008) ProgressMgr StepClass ABC 6 ABBROWSE.INC
(8) Class Instances Found In SQLQueryDirectToOrdersReport


 
PROCEDURE (23):
QueryParser_ABCBrowse (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 82 ABBROWSE.INC
(0002) BRW1::EIPManager BrowseEIPManager ABC 45 ABBROWSE.INC
(0003) HQry5 HNDBrwFilter HND 245 HNDBRWFL.INC
(0004) HWin11 HNDWindow HND 197 HNDWINDO.INC
(0005) VisitMe2 HNDWindow HND 197 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 38 ABWINDOW.INC
(13) Class Instances Found In QueryParser_ABCBrowse


 
PROCEDURE (24):
SQLFilter_LocatorOverRideControl (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) BRW1 BrowseClass ABC 82 ABBROWSE.INC
(0002) BRW7 BrowseClass ABC 82 ABBROWSE.INC
(0003) BRW1::EIPManager BrowseEIPManager ABC 45 ABBROWSE.INC
(0004) HBrw5 HNDBrowse HND 354 HNDBROWS.INC
(0005) HBrw8 HNDBrowse HND 354 HNDBROWS.INC
(0006) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0007) HSizes8 HNDSizes HND 23 HNDSIZES.INC
(0008) HWin4 HNDWindow HND 197 HNDWINDO.INC
(0009) VisitMe2 HNDWindow HND 197 HNDWINDO.INC
(0010) BRW1::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0011) BRW1::Sort1:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0012) BRW1::Sort2:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0013) BRW1::Sort3:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0014) BRW1::Sort4:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0015) BRW7::Sort0:Locator StepLocatorClass ABC 12 ABBROWSE.INC
(0016) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0017) ThisWindow WindowManager ABC 38 ABWINDOW.INC
(17) Class Instances Found In SQLFilter_LocatorOverRideControl


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

chtlogo001.gif Classes By Procedure In HNDACCES.APP