Application Templates
|
This application demonstrates CHT ListBoxBrowseExtender used in an SQL setting. An ordinary Clarion list box is used to build a ABC-style browse resembling HandyMarkerBrowse. It illustrates these concepts: • • • An LBX browse with UniversalQueryControl_LBX • • • An LBX browse with InQueueQueryControl_LBX • • • Connecting an update form with UpdateButtons_LBX • • • PROCEDURE: LBXWithUniversalQueryControl() The browse queue is loaded without pre-filter initially from the data table. The query control provides for entry of CHT queries which will re-fill the "Main" queue with a new subset of data directly from the data table while "Main Queue Data" is displayed. Click over to the "Shadow Queue Data" and CHT queries in the query control will display subsets of the "Main" data queue without data table access being excercised. Clearing the Main Queue Data query control reloads the Main queue from the data table. • • • PROCEDURE: LBXWithInQueueQueryTemplate() The browse queue is loaded without pre-filter initially from the data table. The query control provides for entry of a CHT query string. Records matching the query string are inserted into the "Shadow" queue which is then displayed. "Main" queue records remain undisturbed. Clearing the query empties the shadow queue and re-displays the Main queue. No file access is required after the initial data load from the data tables. A reset from file button, reloads the main queue from the data tables. 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. |
| Count | Global Template Name | Qty | Global Template Description | |
| (0001) | AACHTControlPanel(HNDTools) | 1 | © CHT AACHTControlPanel • (TIER-1) • | |
| (0002) | ApplicationImagesEx(HNDTools) | 1 | © CHT ApplicationImagesEx • (TIER-1) • | |
| (0003) | GlobalIncludeHNDDiskFunctions(HNDTools) | 1 | © CHT GlobalIncludeHNDDiskFunctions • (TIER-2) • | |
| (0004) | HNDCMPControlPanel(HNDTools) | 1 | © CHT HNDCMPControlPanel • (TIER-2) • | |
| (0005) | HandyVersionResource(HNDTools) | 1 | © CHT HandyVersionResource • (TIER-1) • | |
| (0006) | INIFile(HNDTools) | 1 | © CHT INIFile • (TIER-1) • | |
| (0007) | VblFileNames(HNDTools) | 1 | © CHT VblFileNames • (TIER-1) • | |
| (7) Global Templates • (TIER-2) | ||||
| 1 – Template Type: Window | ||||
| – – Procedure Name: LBXWith_BUILT_IN_LocatorOnly() | ||||
| Version 6.02.00, added an example of FillViewFromQueue() onto this procedure. | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0008) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0009) | HandyProcedureDocs(HNDTools) | 1 | © CHT HandyProcedureDocs • (TIER-1) • | |
| (0010) | HandyProcedureStartButton(HNDTools) | 1 | © CHT HandyProcedureStartButton • (TIER-2) • (CODE-TABS) • (13) | |
| (0011) | HandyThreadLimiter(HNDTools) | 1 | © CHT HandyThreadLimiter • (TIER-1) • | |
| (0012) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
| (0013) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
| (0014) | ListBoxBrowseExtender(HNDTools) | 1 | © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (3) | |
| (0015) | MaxPreLoadRecordControl_LBX(HNDTools) | 1 | © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (10) | |
| (0016) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0017) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
| (0018) | UpdateButtons_LBX(HNDTools) | 1 | © CHT UpdateButtons_LBX • (TIER-3) • (8) | |
| (11) Local Templates • (TIER-3) | ||||
| 2 – Template Type: Splash | ||||
| – – Procedure Name: JumpStartSplashCHTBlue() | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0019) | AppBuildDateTimeStamp(HNDTools) | 1 | © CHT AppBuildDateTimeStamp • (TIER-2) • | |
| (0020) | AppBuildNumberStamp(HNDTools) | 1 | © CHT AppBuildNumberStamp • (TIER-2) • | |
| (0021) | AppCopyRightStamp(HNDTools) | 1 | © CHT AppCopyRightStamp • (TIER-2) • | |
| (0022) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0023) | HandyTellMeControl(HNDTools) | 1 | © CHT HandyTellMeControl • (TIER-2) • (2) | |
| (0024) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (6) Local Templates • (TIER-3) | ||||
| 3 – Template Type: Window | ||||
| – – Procedure Name: CompanyUpdateForm() | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0025) | CancelButton(ABC) | 1 | Cancel the Current Operation | |
| (0026) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0027) | FormVCRControls(ABC) | 1 | Allow Form to be driven by Toolbar VCR Controls | |
| (0028) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
| (0029) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0030) | RecordValidation(ABC) | 1 | Validate a record against the dictionary | |
| (0031) | SaveButton(ABC) | 1 | Update Customers record on disk | |
| (7) Local Templates • (TIER-3) | ||||
| 4 – Template Type: Window | ||||
| – – Procedure Name: LBXWith_IN_QUEUE_QueryTemplate() | ||||
| Version 6.02.00, added an example of FillViewFromQueue() onto this procedure. | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0032) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0033) | HandyProcedureDocs(HNDTools) | 1 | © CHT HandyProcedureDocs • (TIER-1) • | |
| (0034) | HandyProcedureStartButton(HNDTools) | 1 | © CHT HandyProcedureStartButton • (TIER-2) • (CODE-TABS) • (6) | |
| (0035) | HandyThreadLimiter(HNDTools) | 1 | © CHT HandyThreadLimiter • (TIER-1) • | |
| (0036) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
| (0037) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
| (0038) | InQueueQueryControl_LBX(HNDTools) | 1 | © CHT InQueueQueryControl_LBX - • (TIER-3) • | |
| (0039) | ListBoxBrowseExtender(HNDTools) | 1 | © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (3) | |
| (0040) | MaxPreLoadRecordControl_LBX(HNDTools) | 1 | © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (10) | |
| (0041) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0042) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
| (0043) | UpdateButtons_LBX(HNDTools) | 1 | © CHT UpdateButtons_LBX • (TIER-3) • (8) | |
| (12) Local Templates • (TIER-3) | ||||
| 5 – Template Type: Window | ||||
| – – Procedure Name: LBXWith_UNIVERSAL_QUERY_Control() | ||||
| Version 6.02.00, added an example of FillViewFromQueue() onto this procedure. | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0044) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0045) | HandyProcedureDocs(HNDTools) | 1 | © CHT HandyProcedureDocs • (TIER-1) • | |
| (0046) | HandyProcedureStartButton(HNDTools) | 1 | © CHT HandyProcedureStartButton • (TIER-2) • (CODE-TABS) • (6) | |
| (0047) | HandyThreadLimiter(HNDTools) | 1 | © CHT HandyThreadLimiter • (TIER-1) • | |
| (0048) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
| (0049) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
| (0050) | ListBoxBrowseExtender(HNDTools) | 1 | © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (3) | |
| (0051) | MaxPreLoadRecordControl_LBX(HNDTools) | 1 | © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (8) | |
| (0052) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0053) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
| (0054) | UniversalQueryControl_LBX(HNDTools) | 1 | © CHT UniversalQueryControl_LBX • (TIER-3) • (10) | |
| (0055) | UpdateButtons_LBX(HNDTools) | 1 | © CHT UpdateButtons_LBX • (TIER-3) • (12) | |
| (12) Local Templates • (TIER-3) | ||||
| 6 – Template Type: Report | ||||
| – – Procedure Name: CHTQueryToReport() | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0056) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0057) | HandyQueryReportLimiter(HNDTools) | 1 | © CHT HandyQueryReportLimiter • (TIER-1) • | |
| (0058) | HandyTellMeControl(HNDTools) | 1 | © CHT HandyTellMeControl • (TIER-2) • (5) | |
| (0059) | PauseButton(ABC) | 1 | Pause the Process | |
| (0060) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0061) | SetSQLAliasesToFilePrefix(HNDTools) | 1 | © CHT SetSQLAliasesToFilePrefix • (TIER-1) • | |
| (6) Local Templates • (TIER-3) | ||||
| 7 – Template Type: Frame | ||||
| – – Procedure Name: MainEntryPoint() | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0062) | EmbedRegistryFunctions(HNDTools) | 1 | © CHT EmbedRegistryFunctions • (TIER-2) • | |
| (0063) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0064) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (3) Local Templates • (TIER-3) | ||||