GENERATED: FEB 13,2021 - 5:25PM
BROWSES LBX (SQL) [V10.21.02]

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 - CHT Global Control Panel (hndtools.tpl)
(0002) ApplicationImagesEx(HNDTools) 1 © CHT ApplicationImagesEx - Application Styling System
(0003) HNDCMPControlPanel(HNDTools) 1 © CHT PROJECT BUILDER SUPPORT - Interface to the CHT Project Builder.
(0004) HandyCodeSigningExtension(HNDTools) 1 © CHT HandyCodeSigningExtension - Application Code-Signing System
(0005) HandyVersionResource(HNDTools) 1 © CHT HandyVersionResource - Version Resource/Build Number Information To EXE
(0006) INIFile(HNDTools) 1 © CHT INIFile - .INI FIle and Registry extension classes - HNDIni - globally to your application.
(0007) VblFileNames(HNDTools) 1 © CHT VblFileNames - Incorporate variable file names and defaults into your app from the dictionary.
(7) Global Templates Found

1 - Procedure Template Type: Report
CHTQueryToOrdersReport (*STRING xIncomingQuery, STRING xOrder)
Count Local Template Name Qty Local Template Description
(0008) HandyQueryReportLimiter(HNDTools) 1 © CHT HandyQueryReportLimiter - Limit reported records via passed-in query or filter.
(0009) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl - Text box control to provide a message or help text.
(0010) PauseButton(ABC) 1 Pause the Process
(0011) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(4) Local Templates Found In CHTQueryToOrdersReport

2 - Procedure Template Type: Window
ListBoxBrowseExtenderProcedure ()
Version 6.02.00, added an example of FillViewFromQueue() onto this procedure.
Count Local Template Name Qty Local Template Description
(0012) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin11 An Instance Of: HNDWindow
(0013) HandyProcedureDocs(HNDTools) 1 © CHT HandyProcedureDocs - A template to document your procedures.
(0014) HandyQueryReportButton(HNDTools) 1 © CHT HandyQueryReportButton - Start a HandyQueryReportLimiter-extended report procedure.(6)
(0015) HandyThreadLimiter(HNDTools) 1 © CHT HandyThreadLimiter - Limit threaded procedures to one instance.
(0016) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0017) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0018) ListBoxBrowseExtender(HNDTools) 1 © CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0019) MaxPreLoadRecordControl_LBX(HNDTools) 1 © CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0020) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0021) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(0022) SortOrderFieldFilter_LBX(HNDTools) 1 © CHT SortOrderFieldFilter_LBX - Filters ListBoxBrowseExtender browses on the sort order column
(0023) UpdateButtons_LBX(HNDTools) 1 © CHT UpdateButtons_LBX (ListBoxBrowseExtender) Browse Update Buttons
(12) Local Templates Found In ListBoxBrowseExtenderProcedure

3 - Procedure Template Type: Source
RegisterODBC ()
Count Local Template Name Qty Local Template Description
(0024) EmbedObject(HNDTools) 2 © CHT EmbedObject - HDisk An Instance Of: HNDDisk
(0025) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(2) Local Templates Found In RegisterODBC

4 - Procedure Template Type: Splash
JumpStartSplashCHTBlue ()
Count Local Template Name Qty Local Template Description
(0026) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0027) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp - An application build number or version stamp.
(0028) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp - An application copyright stamp.
(0029) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl - Text box control to provide a message or help text.
(0030) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(5) Local Templates Found In JumpStartSplashCHTBlue

5 - Procedure Template Type: Frame
MainEntryPoint ()
Count Local Template Name Qty Local Template Description
(0031) EmbedDiskFunctions(HNDTools) 1 © CHT EmbedDiskFunctions - Disk Functions Classes - HDisk An Instance Of: HNDDisk
(0032) EmbedRegistryFunctions(HNDTools) 1 © CHT EmbedRegistryFunctions - HReg An Instance Of: HNDRegistry
(0033) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin An Instance Of: HNDWindow
(0034) HandyHelpFileFetch(HNDTools) 5 © CHT HandyHelpFileFetch - Build A Help File Request To Your Website.(10)
(0035) HandyHelpWhatsNew(HNDTools) 1 © CHT HandyHelpWhatsNew - Build A What's New Request To Your Website.(8)
(0036) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(6) Local Templates Found In MainEntryPoint

6 - Procedure Template Type: Window
CompanyUpdateForm ()
Count Local Template Name Qty Local Template Description
(0037) CancelButton(ABC) 1 Cancel the Current Operation
(0038) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin10 An Instance Of: HNDWindow
(0039) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0040) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0041) RecordValidation(ABC) 1 Validate a record against the dictionary
(0042) SaveButton(ABC) 1 Update Customers record on disk
(6) Local Templates Found In CompanyUpdateForm

Copyright © 1996-2021 - CHT Version: [25A.01.00]
Gus M. Creces, CHT - Clarion Handy Tools
All Rights Reserved Worldwide

chtlogo001.gif
Application Templates