Templates In Application: HNDSQL2.APP
|
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) |
| Count | Global Template Name | Qty | Global Template Description | |
| (0001) | AACHTControlPanel(HNDTools) | 1 | AACHTControlPanel - CHT Global Control Panel. | |
| (0002) | ApplicationImagesEx(HNDTools) | 1 | ApplicationImagesEx - A tool to better control the use of images and icons in your application. | |
| (0003) | HNDCMPControlPanel(HNDTools) | 1 | HNDCMPControlPanel - Interface to the CHT Compile Manager. | |
| (0004) | HandyVersionResource(HNDTools) | 1 | HandyVersionResource - Version Resource/Build Number Information To EXE | |
| (0005) | INIFile(HNDTools) | 1 | INIFile - Attach CHT .INI FIle and Registry extension classes - HNDIni - globally to your application. | |
| (0006) | VblFileNames(HNDTools) | 1 | VblFileNames - Incorporate variable file names and defaults into your app from the dictionary. | |
| (6) Global Templates Found | ||||
| 1 - Procedure Template Type: IniTableIOProcedure | ||||
| IniTableIOProcedure (BYTE xIoType, STRING xSector, STRING xName, <STRING xValue>, <STRING xFilename>),STRING,PROC | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0007) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (1) Local Templates Found In IniTableIOProcedure | ||||
| 2 - Procedure Template Type: Window | ||||
| SQLFilter_HandyMarkerBrowse () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0008) | BrowseBox(ABC) | 1 | Browse on Customers | |
| (0009) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
| (0010) | EmbedDebugViewTrace(HNDTools) | 1 | EmbedDebugViewTrace - Code template to send debug values to DebugView.(8) | |
| (0011) | EmbedWindowFunctions(HNDTools) | 1 | EmbedWindowFunctions - An Instance Of: | |
| (0012) | HandyCOMEventLoggerControl(HNDTools) | 1 | HandyCOMEventLoggerControl - Drop a CHT COM Event Logger Control On Your Application Window.(2) | |
| (0013) | HandyMarkerBrowse(HNDTools) | 1 | HandyMarkerBrowse - Explorer-like ABC browse with record marking on table: Customers | |
| (0014) | HandyMarkerBrowseQueryBuilderControl(HNDTools) | 1 | HandyMarkerBrowseQueryBuilderControl - Attach a CHT Query Builder control to your Clarion Handy Tools HandyMarkerBrowse procedure.(3) | |
| (0015) | HandyThreadLimiter(HNDTools) | 1 | HandyThreadLimiter - Limit threaded procedures to one instance. | |
| (0016) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (9) Local Templates Found In SQLFilter_HandyMarkerBrowse | ||||
| 3 - Procedure Template Type: Source | ||||
| RegisterODBC () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0017) | EmbedObject(HNDTools) | 2 | EmbedObject - An Instance Of: | |
| (0018) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (2) Local Templates Found In RegisterODBC | ||||
| 4 - Procedure Template Type: Splash | ||||
| JumpStartSplashCHTBlue () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0019) | AppBuildDateTimeStamp(HNDTools) | 1 | AppBuildDateTimeStamp - An application build date/time stamp. | |
| (0020) | AppBuildNumberStamp(HNDTools) | 1 | AppBuildNumberStamp - An application build number or version stamp. | |
| (0021) | AppCopyRightStamp(HNDTools) | 1 | AppCopyRightStamp - An application copyright stamp. | |
| (0022) | HandyTellMeControl(HNDTools) | 1 | HandyTellMeControl - Text box control to provide a message or help text. | |
| (0023) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (5) Local Templates Found In JumpStartSplashCHTBlue | ||||
| 5 - Procedure Template Type: Window | ||||
| UpdateForm () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0024) | CancelButton(ABC) | 1 | Cancel the Current Operation | |
| (0025) | EmbedWindowFunctions(HNDTools) | 1 | EmbedWindowFunctions - An Instance Of: | |
| (0026) | FormVCRControls(ABC) | 1 | Allow Form to be driven by Toolbar VCR Controls | |
| (0027) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (0028) | RecordValidation(ABC) | 1 | Validate a record against the dictionary | |
| (0029) | SaveButton(ABC) | 1 | Update Customers record on disk | |
| (6) Local Templates Found In UpdateForm | ||||
| 6 - Procedure Template Type: Frame | ||||
| MainEntryPoint () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0030) | EmbedDiskFunctions(HNDTools) | 1 | EmbedDiskFunctions - An Instance Of: | |
| (0031) | EmbedRegistryFunctions(HNDTools) | 1 | EmbedRegistryFunctions - An Instance Of: | |
| (0032) | EmbedWindowFunctions(HNDTools) | 1 | EmbedWindowFunctions - An Instance Of: | |
| (0033) | HandyHelpFileFetch(HNDTools) | 2 | HandyHelpFileFetch - Build A Help File Request To Your Website.(7) | |
| (0034) | HandyHelpWhatsNew(HNDTools) | 1 | HandyHelpWhatsNew - Build A What's New Request To Your Website.(8) | |
| (0035) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (6) Local Templates Found In MainEntryPoint | ||||
Templates In Application: HNDSQL2.APP