GENERATED: MAY 4,2023 - 8:46AM
BROWSES LBX (SQL) [V23.04.30. 27.03]

Previous Page
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)

Copyright © 1996-2023 - CHT Version: [27B.00.00]
Gus M. Creces, CLARION HANDY TOOLS
All Rights Reserved Worldwide

chtlogo001.gif
Application Templates