GENERATED: JUL 11,2017 - 12:16AM
ExplorerBrowse SQL Query Demo [V10.17.05.0247]

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

It illustrates these concepts:
• • •  A CHT Query Builder implementation returning SQL in the foreground.
• • •  A hand built SQL query control using an ABC reset field and a standard entry control
• • •  Hiding/unhiding columns programmatically
• • •  Hidden columns are hidden also in CHT Query Builder

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


 
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) 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_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):
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 (6):
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 (7):
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 HNDSQL1.APP