|
This application demonstrates CHT HandyMarkerBrowse used in an SQL setting. It illustrates these concepts: • • • A CHT Query Builder implementation returning SQL in the foreground. • • • An 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): 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 (2): SQLFilter_HandyMarkerBrowse (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) | LOG2 | HNDEventLoggerClass | HND | 50 | HNDEVEER.INC |
| (0004) | HMrkBrw5 | HNDMarkerBrowse | HND | 372 | HNDMRKBR.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 SQLFilter_HandyMarkerBrowse | |||||
| 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): 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 (5): UpdateForm (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 UpdateForm | |||||
| 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 | |||||
Classes By Procedure In HNDSQL2.APP