GENERATED: JUL 10,2017 - 11:51PM
ExplorerBrowse SQL Query Experiment [V10.17.05.0388]

Previous Page
This application demonstrates CHT Explorerbrowse used in an SQL setting.

It illustrates these concepts:
• • •  A CHT ExplorerBrowse implementation returning SQL in the foreground.

• • •  A hand built SQL query control that accepts an SQL-Language filter.

• • •  A hand built CHT query control that accepts a CHT Query-Language filter.

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):
CompanyUpdateForm (Procedure Template: Window)
Count Instance Class Type Methods Header File
(0001) HWin10 HNDWindow HND 214 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 (2):
SQL_ExplorerBrowseHandCodedCHTQuery (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) EXPLOR HNDBrowse HND 431 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles7 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin11 HNDWindow HND 214 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 SQL_ExplorerBrowseHandCodedCHTQuery


 
PROCEDURE (3):
SQL_ExplorerBrowseHandCodedSQLQuery (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) EXPLOR HNDBrowse HND 431 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles7 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin11 HNDWindow HND 214 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 SQL_ExplorerBrowseHandCodedSQLQuery


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


 
PROCEDURE (5):
SQL_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 431 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) Handles7 HNDSizes HND 23 HNDSIZES.INC
(0006) HWin11 HNDWindow HND 214 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 SQL_ExplorerBrowse


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


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


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


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

chtlogo001.gif Classes By Procedure In HNDSQL0.APP