This application demonstrates CHT ListBoxBrowseExtender (LBX) used in an SQL setting. An ordinary Clarion list box is used to build an ABC-style browse resembling HandyMarkerBrowse. Note that no ABC browse template is used here. It illustrates these concepts: • • • Fill browse queue directly from a single file • • • Fill browse queue from multiple files with view • • • Fill browse queue manually by embedding • • • Fill browse queue using method SQLSelect • • • Adding Update Form UpdateButtons_LBX • • • A hand-code managed query control 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: Report | ||||
– – Procedure Name: CHTQueryToOrdersReport() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0008) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0009) | HandyQueryReportLimiter(HNDTools) | 1 | © CHT HandyQueryReportLimiter • (TIER-1) • | |
(0010) | HandyTellMeControl(HNDTools) | 1 | © CHT HandyTellMeControl • (TIER-2) • (5) | |
(0011) | PauseButton(ABC) | 1 | Pause the Process | |
(0012) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(5) Local Templates • (TIER-2) | ||||
2 – Template Type: Window | ||||
– – Procedure Name: ListBoxBrowseExtenderProcedure() | ||||
Version 6.02.00, added an example of FillViewFromQueue() onto this procedure. | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0013) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0014) | HandyEmbedFromTemplateButton(HNDTools) | 5 | © CHT HandyEmbedFromTemplateButton • (TIER-1) • (CODE-TABS) • (15) | |
(0015) | HandyProcedureDocs(HNDTools) | 1 | © CHT HandyProcedureDocs • (TIER-1) • | |
(0016) | HandyProcedureStartButton(HNDTools) | 1 | © CHT HandyProcedureStartButton • (TIER-2) • (CODE-TABS) • (8) | |
(0017) | HandyThreadLimiter(HNDTools) | 1 | © CHT HandyThreadLimiter • (TIER-1) • | |
(0018) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
(0019) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
(0020) | ListBoxBrowseExtender(HNDTools) | 1 | © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (3) | |
(0021) | MaxPreLoadRecordControl_LBX(HNDTools) | 1 | © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (13) | |
(0022) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0023) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
(0024) | SortOrderFieldFilter_LBX(HNDTools) | 1 | © CHT SortOrderFieldFilter_LBX • (TIER-3) • | |
(0025) | UpdateButtons_LBX(HNDTools) | 1 | © CHT UpdateButtons_LBX • (TIER-3) • (9) | |
(13) Local Templates • (TIER-3) | ||||
3 – Template Type: Splash | ||||
– – Procedure Name: JumpStartSplashCHTBlue() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0026) | AppBuildDateTimeStamp(HNDTools) | 1 | © CHT AppBuildDateTimeStamp • (TIER-2) • | |
(0027) | AppBuildNumberStamp(HNDTools) | 1 | © CHT AppBuildNumberStamp • (TIER-2) • | |
(0028) | AppCopyRightStamp(HNDTools) | 1 | © CHT AppCopyRightStamp • (TIER-2) • | |
(0029) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0030) | HandyTellMeControl(HNDTools) | 1 | © CHT HandyTellMeControl • (TIER-2) • (2) | |
(0031) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(6) Local Templates • (TIER-3) | ||||
4 – Template Type: Frame | ||||
– – Procedure Name: MainEntryPoint() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0032) | EmbedRegistryFunctions(HNDTools) | 1 | © CHT EmbedRegistryFunctions • (TIER-2) • | |
(0033) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0034) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(3) Local Templates • (TIER-3) | ||||
5 – Template Type: Window | ||||
– – Procedure Name: CompanyUpdateForm() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0035) | CancelButton(ABC) | 1 | Cancel the Current Operation | |
(0036) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0037) | FormVCRControls(ABC) | 1 | Allow Form to be driven by Toolbar VCR Controls | |
(0038) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
(0039) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0040) | RecordValidation(ABC) | 1 | Validate a record against the dictionary | |
(0041) | SaveButton(ABC) | 1 | Update Customers record on disk | |
(7) Local Templates • (TIER-3) | ||||