GENERATED: JUL 19,2019 - 1:06PM
BROWSES LBX (SQL) [V10.19.07]

Previous Page
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 - CHT Global Control Panel.
(0002) ApplicationImagesEx(HNDTools) 1 CHT ApplicationImagesEx - Application Styling System
(0003) HNDCMPControlPanel(HNDTools) 1 CHT HNDCMPControlPanel - Interface to the CHT Compile Manager.
(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: Window
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 - An Instance Of:
(0009) HandyProcedureDocs(HNDTools) 1 CHT HandyProcedureDocs - A template to document your procedures.
(0010) HandyQueryReportButton(HNDTools) 1 CHT HandyQueryReportButton - Start a HandyQueryReportLimiter-extended report procedure.(6)
(0011) HandyThreadLimiter(HNDTools) 1 CHT HandyThreadLimiter - Limit threaded procedures to one instance.
(0012) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0013) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0014) ListBoxBrowseExtender(HNDTools) 1 CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0015) MaxPreLoadRecordControl_LBX(HNDTools) 1 CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0016) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0017) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(0018) UpdateButtons_LBX(HNDTools) 1 CHT UpdateButtons_LBX (ListBoxBrowseExtender) Browse Update Buttons
(11) Local Templates Found In LBXWith_BUILT_IN_LocatorOnly

2 - Procedure Template Type: Splash
JumpStartSplashCHTBlue ()
Count Local Template Name Qty Local Template Description
(0019) AppBuildDateTimeStamp(HNDTools) 1 CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0020) AppBuildNumberStamp(HNDTools) 1 CHT AppBuildNumberStamp - An application build number or version stamp.
(0021) AppCopyRightStamp(HNDTools) 1 CHT AppCopyRightStamp - An application copyright stamp.
(0022) HandyTellMeControl(HNDTools) 1 CHT HandyTellMeControl - Text box control to provide a message or help text.
(0023) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(5) Local Templates Found In JumpStartSplashCHTBlue

3 - Procedure Template Type: Window
CompanyUpdateForm ()
Count Local Template Name Qty Local Template Description
(0024) CancelButton(ABC) 1 Cancel the Current Operation
(0025) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0026) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0027) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0028) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0029) RecordValidation(ABC) 1 Validate a record against the dictionary
(0030) SaveButton(ABC) 1 Update Customers record on disk
(7) Local Templates Found In CompanyUpdateForm

4 - Procedure Template Type: Window
LBXWith_IN_QUEUE_QueryTemplate ()
Version 6.02.00, added an example of FillViewFromQueue() onto this procedure.
Count Local Template Name Qty Local Template Description
(0031) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0032) HandyProcedureDocs(HNDTools) 1 CHT HandyProcedureDocs - A template to document your procedures.
(0033) HandyQueryReportButton(HNDTools) 1 CHT HandyQueryReportButton - Start a HandyQueryReportLimiter-extended report procedure.(6)
(0034) HandyThreadLimiter(HNDTools) 1 CHT HandyThreadLimiter - Limit threaded procedures to one instance.
(0035) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0036) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0037) InQueueQueryControl_LBX(HNDTools) 1 CHT InQueueQueryControl_LBX - Filters ListBoxBrowseExtender browses in queue on all columns
(0038) ListBoxBrowseExtender(HNDTools) 1 CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0039) MaxPreLoadRecordControl_LBX(HNDTools) 1 CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0040) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0041) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(0042) UpdateButtons_LBX(HNDTools) 1 CHT UpdateButtons_LBX (ListBoxBrowseExtender) Browse Update Buttons
(12) Local Templates Found In LBXWith_IN_QUEUE_QueryTemplate

5 - Procedure Template Type: Source
RegisterODBC ()
Count Local Template Name Qty Local Template Description
(0043) EmbedObject(HNDTools) 2 CHT EmbedObject - An Instance Of:
(0044) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(2) Local Templates Found In RegisterODBC

6 - Procedure Template Type: Window
LBXWith_UNIVERSAL_QUERY_Control ()
Version 6.02.00, added an example of FillViewFromQueue() onto this procedure.
Count Local Template Name Qty Local Template Description
(0045) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0046) HandyProcedureDocs(HNDTools) 1 CHT HandyProcedureDocs - A template to document your procedures.
(0047) HandyQueryReportButton(HNDTools) 1 CHT HandyQueryReportButton - Start a HandyQueryReportLimiter-extended report procedure.(6)
(0048) HandyThreadLimiter(HNDTools) 1 CHT HandyThreadLimiter - Limit threaded procedures to one instance.
(0049) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0050) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0051) ListBoxBrowseExtender(HNDTools) 1 CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0052) MaxPreLoadRecordControl_LBX(HNDTools) 1 CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0053) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0054) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(0055) UniversalQueryControl_LBX(HNDTools) 1 CHT UniversalQueryControl_LBX - Filters ListBoxBrowseExtender from DATA SOURCE or from MAIN QUEUE(10)
(0056) UpdateButtons_LBX(HNDTools) 1 CHT UpdateButtons_LBX (ListBoxBrowseExtender) Browse Update Buttons
(12) Local Templates Found In LBXWith_UNIVERSAL_QUERY_Control

7 - Procedure Template Type: Report
CHTQueryToReport (*STRING xQuery, STRING xOrder)
Count Local Template Name Qty Local Template Description
(0057) HandyQueryReportLimiter(HNDTools) 1 CHT HandyQueryReportLimiter - Limit reported records via passed-in query or filter.
(0058) HandyTellMeControl(HNDTools) 1 CHT HandyTellMeControl - Text box control to provide a message or help text.
(0059) PauseButton(ABC) 1 Pause the Process
(0060) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0061) SetSQLAliasesToFilePrefix(HNDTools) 1 CHT SetSQLAliasesToFilePrefix - Sets Aliases Of View Files To DCT File Prefixes
(5) Local Templates Found In CHTQueryToReport

8 - Procedure Template Type: Frame
MainEntryPoint ()
Count Local Template Name Qty Local Template Description
(0062) CHTBestPracticeEmbedClass(HNDTools) 1 CHT CHTBestPracticeEmbedClass CHT Best Practice Embedding Assistant
(0063) EmbedDiskFunctions(HNDTools) 1 CHT EmbedDiskFunctions - Disk Functions Classes - An Instance Of:
(0064) EmbedRegistryFunctions(HNDTools) 1 CHT EmbedRegistryFunctions - An Instance Of:
(0065) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0066) HandyHelpFileFetch(HNDTools) 5 CHT HandyHelpFileFetch - Build A Help File Request To Your Website.(10)
(0067) HandyHelpWhatsNew(HNDTools) 1 CHT HandyHelpWhatsNew - Build A What's New Request To Your Website.(8)
(0068) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(7) Local Templates Found In MainEntryPoint

Copyright © 1996-2019 - CHT Version: [23C.01.00]
Gus M. Creces and The Clarion Handy Tools Page.
All Rights Reserved Worldwide

chtlogo001.gif Templates In Application: HNDLBXSQLEX.APP