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

Previous Page

This application demonstrates primarily a record-marking template, that assists in marking records using ordinary Clarion list boxes.

That template is called ListBoxBrowseExtender or "LBX" for short.

Some Features Illustrated In This Application:
•  ListBoxBrowseExtender Has Green Bar.
•  LBX has multiple optional Query Control templates (_LBX)
•  Optionally use ORDER BY In Query Control For Mult-Column Sort.
•  ListBoxBrowseExtender Honours Retain-Record.
•  ListBoxBrowseExtender Generates Data Queue
•  ListBoxBrowseExtender connects update forms
•  ListBoxBrowseExtender has queue auto-fill on startup
•  LBX has optional pre-filter to limit auto-fill on startup
•  LBX has selectable fill-queue methods for local or remote data

Six example procedures illustate some powerful LBX features;

•  PROCEDURE:
LBX_1_ListBoxBrowseExtenderInQueueQuery()
This procedure illustrates a query template called InQueueQueryControl_LBX. This control filters the records already in the list box queue, into a secondary queue called "the shadow queue" and displays the result in the same browse. Clearing this filter resets to the starting or "Main" queue and displays the original record set. All of this except the original fill-queue happens without ANY further file access being needed.

•  PROCEDURE:
LBX_2_ListBoxBrowseExtenderSortOrderFieldFilter()
This procedure illustrates a template called SortOrderFieldFilter_LBX. This control requires the user to enter only a string of characters to match something contained in the sort-order field. As above, matching data are inserted into the shadow queue and are displayed in the same browse. As above, also, clearing this filter resets to and displays the "Main" queue record set.

•  PROCEDURE:
LBX_3_ListBoxBrowseExtenderUniversalQueryControl()
This procedure illustrates a template called UniversalQueryControl_LBX. This control when empty fills the queue with all table/view records unless a pre-filter is added to the template config. Click the "Queue Data" button to switch to the "Shadow Queue" and enter a query. These records are filtered from the Main queue into the Shadow queue. Click back on the "Queue Data" button and the browse switches back to the Main queue with all original records intact.

•  PROCEDURE:
LBX_4_ListBoxBrowseExtenderPopFavoriteQueries()
This procedure populates a template called PopFavoriteQueries_LBX. This control opens a table called PreQueries and scans it for queries designated for the view name defined on the template. Queries may be optionally added, or deleted at run time and can be selected from a popup menu. The PreQueries table is defined in HNDO.DCT from which it can be imported into your own dictionary. Prequeries may be ISAM or SQL as required by your application.

•  PROCEDURE:
LBX_5_ListBoxBrowseExtenderConditionalIconsOneColumn()
This procedure populates a template called UniversalQueryControl_LBX as above, but its purpose is primarily to illustrate conditional icons. These are icons on a column or columns which change based on some conditional expression related to the data in that column. In this case columns beginning with A, B, C and D are assigned icons 1, 2, 3, and 4. To see the effect of this, set the "Max Pre-Load" value to at least 1000 and click the NAME column to sort from smallest to largest.

•  PROCEDURE:
LBX_6_ListBoxBrowseExtenderConditionalIconsTwoColumns()
This procedure populates a template called UniversalQueryControl_LBX as above, but its purpose is primarily to illustrate conditional icons. These are icons on a column or columns which change based on some conditional expression related to the data in that column. To see the effect, set the "Max Pre-Load" value to at least 1000 and click the SSN or NAME columns to sort from smallest to largest.

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) GlobalTransparentControls(HNDTools) 1 CHT GlobalTransparentControls - Globally Add Transparency To Your Window/Report Controls
(0004) HNDCMPControlPanel(HNDTools) 1 CHT HNDCMPControlPanel - Interface to the CHT Compile Manager.
(0005) HandyCodeSigningExtension(HNDTools) 1 CHT HandyCodeSigningExtension - Application Code-Signing System
(0006) HandyVersionResource(HNDTools) 1 CHT HandyVersionResource - Version Resource/Build Number Information To EXE
(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: Frame
Main ()
Count Local Template Name Qty Local Template Description
(0008) DateTimeDisplay(ABC) 1 Display the date and/or time in the current window
(0009) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0010) HandyHelpWhatsNew(HNDTools) 1 CHT HandyHelpWhatsNew - Build A What's New Request To Your Website.(5)
(0011) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0012) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(5) Local Templates Found In Main

2 - Procedure Template Type: Window
LBX_1_ListBoxBrowseExtenderInQueueQuery ()
Count Local Template Name Qty Local Template Description
(0013) CloseButton(ABC) 1 Close the Window
(0014) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0015) HandyHelpFileTopicEmbed(HNDTools) 1 CHT Embed a call to launch help file topic.(10)
(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) InQueueQueryControl_LBX(HNDTools) 1 CHT InQueueQueryControl_LBX - Filters ListBoxBrowseExtender browses in queue on all columns
(0019) ListBoxBrowseExtender(HNDTools) 1 CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0020) MaxPreLoadRecordControl_LBX(HNDTools) 1 CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0021) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0022) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(0023) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(11) Local Templates Found In LBX_1_ListBoxBrowseExtenderInQueueQuery

3 - Procedure Template Type: ListBoxBrowseExtenderClientServerBrowse
LBX_5_ListBoxBrowseExtenderConditionalIconsOneColumn ()
Count Local Template Name Qty Local Template Description
(0024) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0025) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0026) HandyWindowDismissButton(HNDTools) 1 CHT HandyWindowDismissButton - Dismisses a window to the task bar by minimizing and hiding it.
(0027) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0028) ListBoxBrowseExtender(HNDTools) 1 CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0029) MaxPreLoadRecordControl_LBX(HNDTools) 1 CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0030) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0031) ResizeHandlesControl(HNDTools) 1 CHT ResizeHandlesControl - Attach "grip-style" resize handles to any window.
(0032) UniversalQueryControl_LBX(HNDTools) 1 CHT UniversalQueryControl_LBX - Filters ListBoxBrowseExtender from DATA SOURCE or from MAIN QUEUE(2)
(0033) UpdateButtons_LBX(HNDTools) 1 CHT UpdateButtons_LBX (ListBoxBrowseExtender) Browse Update Buttons
(10) Local Templates Found In LBX_5_ListBoxBrowseExtenderConditionalIconsOneColumn

4 - Procedure Template Type: Browse
JumpStartManagePreBuiltQueriesIsam ()
Count Local Template Name Qty Local Template Description
(0034) BrowseBox(ABC) 1 Browse on PreQueries ()
(0035) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on PreQueries
(0036) CloseButton(ABC) 1 Close the Window
(0037) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0038) ExplorerBrowse(HNDTools) 1 CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: PreQueries
(0039) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0040) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0041) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0042) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(0043) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(10) Local Templates Found In JumpStartManagePreBuiltQueriesIsam

5 - Procedure Template Type: Window
LBX_4_ListBoxBrowseExtenderPopFavoriteQueries ()
Count Local Template Name Qty Local Template Description
(0044) CloseButton(ABC) 1 Close the Window
(0045) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0046) HandyHelpFileTopicEmbed(HNDTools) 1 CHT Embed a call to launch help file topic.(10)
(0047) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0048) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0049) ListBoxBrowseExtender(HNDTools) 1 CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0050) MaxPreLoadRecordControl_LBX(HNDTools) 1 CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0051) PopFavoriteQueries_LBX(HNDTools) 1 CHT PopFavoriteQueries_LBX - Pop up pre-built queries and macros - a companion for ListBoxBrowseExtender.
(0052) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0053) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(0054) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(11) Local Templates Found In LBX_4_ListBoxBrowseExtenderPopFavoriteQueries

6 - Procedure Template Type: Window
LBX_2_ListBoxBrowseExtenderSortOrderFieldFilter ()
Count Local Template Name Qty Local Template Description
(0055) CloseButton(ABC) 1 Close the Window
(0056) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0057) HandyHelpFileTopicEmbed(HNDTools) 1 CHT Embed a call to launch help file topic.(10)
(0058) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0059) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0060) ListBoxBrowseExtender(HNDTools) 1 CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0061) MaxPreLoadRecordControl_LBX(HNDTools) 1 CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0062) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0063) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(0064) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(0065) SortOrderFieldFilter_LBX(HNDTools) 1 CHT SortOrderFieldFilter_LBX - Filters ListBoxBrowseExtender browses on the sort order column
(11) Local Templates Found In LBX_2_ListBoxBrowseExtenderSortOrderFieldFilter

7 - Procedure Template Type: Splash
JumpStartSplash07 ()
Count Local Template Name Qty Local Template Description
(0066) AppBuildDateTimeStamp(HNDTools) 1 CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0067) AppBuildNumberStamp(HNDTools) 1 CHT AppBuildNumberStamp - An application build number or version stamp.
(0068) AppCopyRightStamp(HNDTools) 1 CHT AppCopyRightStamp - An application copyright stamp.
(0069) HandyTellMeControl(HNDTools) 1 CHT HandyTellMeControl - Text box control to provide a message or help text.
(0070) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0071) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(6) Local Templates Found In JumpStartSplash07

8 - Procedure Template Type: Window
LBX_3_ListBrowseExtenderUniversalQueryControl ()
Count Local Template Name Qty Local Template Description
(0072) CloseButton(ABC) 1 Close the Window
(0073) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0074) HandyHelpFileTopicEmbed(HNDTools) 1 CHT Embed a call to launch help file topic.(10)
(0075) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0076) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0077) ListBoxBrowseExtender(HNDTools) 1 CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0078) MaxPreLoadRecordControl_LBX(HNDTools) 1 CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0079) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0080) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(0081) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(0082) UniversalQueryControl_LBX(HNDTools) 1 CHT UniversalQueryControl_LBX - Filters ListBoxBrowseExtender from DATA SOURCE or from MAIN QUEUE(8)
(11) Local Templates Found In LBX_3_ListBrowseExtenderUniversalQueryControl

9 - Procedure Template Type: ListBoxBrowseExtenderClientServerBrowse
LBX_6_ListBoxBrowseExtenderConditionalIconsTwoColumns ()
Count Local Template Name Qty Local Template Description
(0083) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0084) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0085) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0086) ListBoxBrowseExtender(HNDTools) 1 CHT ListboxBrowseExtender - An ABC Browse Replacement.
(0087) MaxPreLoadRecordControl_LBX(HNDTools) 1 CHT MaxPreLoadRecordControl_LBX (ListBoxBrowseExtender) Browse Max Pre-load Records Control
(0088) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0089) ResizeHandlesControl(HNDTools) 1 CHT ResizeHandlesControl - Attach "grip-style" resize handles to any window.
(0090) UniversalQueryControl_LBX(HNDTools) 1 CHT UniversalQueryControl_LBX - Filters ListBoxBrowseExtender from DATA SOURCE or from MAIN QUEUE(2)
(0091) UpdateButtons_LBX(HNDTools) 1 CHT UpdateButtons_LBX (ListBoxBrowseExtender) Browse Update Buttons
(9) Local Templates Found In LBX_6_ListBoxBrowseExtenderConditionalIconsTwoColumns

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: HNDLBXDM.APP