GENERATED: MAR 31,2012 - 3:09PM
ExplorerBrowse SQL Query Demo [V8.01.00]

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 197 HNDWINDO.INC
(0002) Toolbar ToolbarClass ABC 6 ABTOOLBA.INC
(0003) ToolbarForm ToolbarUpdateClass ABC 4 ABTOOLBA.INC
(0004) ThisWindow WindowManager ABC 38 ABWINDOW.INC
(4) Class Instances Found In CompanyUpdateForm


 
PROCEDURE (2):
QBReturnSQL_ExplorerBrowse (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) HBrw5 HNDBrowse HND 354 HNDBROWS.INC
(0004) HSizes5 HNDSizes HND 23 HNDSIZES.INC
(0005) HWin11 HNDWindow HND 197 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 38 ABWINDOW.INC
(12) Class Instances Found In QBReturnSQL_ExplorerBrowse


 
PROCEDURE (3):
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 (4):
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 (5):
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 (6):
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


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

chtlogo001.gif Classes By Procedure In HNDSQL1.APP