GENERATED: MAY 4,2023 - 8:27AM
BROWSES LBX (ISAM) [V10.23.04. 27.03]

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 Query Control templates
•  Use ORDER BY In Query For Mult-Column Sort.
•  LBX Honours Retain-Record.
•  LBX Generates Data Queue
•  LBX connects update forms
•  LBX has queue auto-fill on startup
•  LBX has pre-filter to limit auto-fill on startup
•  LBX has 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 • (TIER-1) •
(0002) ApplicationImagesEx(HNDTools) 1 © CHT ApplicationImagesEx • (TIER-1) •
(0003) GlobalTransparentControls(HNDTools) 1 © CHT GlobalTransparentControls (TIER-1)
(0004) HNDCMPControlPanel(HNDTools) 1 © CHT HNDCMPControlPanel • (TIER-2) •
(0005) HandyVersionResource(HNDTools) 1 © CHT HandyVersionResource • (TIER-1) •
(0006) VblFileNames(HNDTools) 1 © CHT VblFileNames • (TIER-1) •
(6) Global Templates • (TIER-2)

 1 – Template Type: Frame
  – – Procedure Name: Main()
Count Local Template Name Qty Local Template Description
(0007) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (5)
(0008) DateTimeDisplay(ABC) 1 Display the date and/or time in the current window
(0009) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0010) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0011) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(5) Local Templates • (TIER-2)

 2 – Template Type: Window
  – – Procedure Name: LBX_1_ListBoxBrowseExtenderInQueueQuery()
Count Local Template Name Qty Local Template Description
(0012) CloseButton(ABC) 1 Close the Window
(0013) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (7)
(0014) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0015) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0016) InQueueQueryControl_LBX(HNDTools) 1 © CHT InQueueQueryControl_LBX - • (TIER-3) •
(0017) ListBoxBrowseExtender(HNDTools) 1 © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (1)
(0018) MaxPreLoadRecordControl_LBX(HNDTools) 1 © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (11)
(0019) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0020) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(0021) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) Local Templates • (TIER-3)

 3 – Template Type: ListBoxBrowseExtenderClientServerBrowse
  – – Procedure Name: LBX_5_ListBoxBrowseExtenderConditionalIconsOneColumn()
Count Local Template Name Qty Local Template Description
(0022) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0023) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0024) HandyWindowDismissButton(HNDTools) 1 © CHT HandyWindowDismissButton • (TIER-2) •
(0025) ListBoxBrowseExtender(HNDTools) 1 © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (1)
(0026) MaxPreLoadRecordControl_LBX(HNDTools) 1 © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (9)
(0027) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0028) ResizeHandlesControl(HNDTools) 1 © CHT ResizeHandlesControl • (TIER-2) •
(0029) UniversalQueryControl_LBX(HNDTools) 1 © CHT UniversalQueryControl_LBX • (TIER-3) • (2)
(0030) UpdateButtons_LBX(HNDTools) 1 © CHT UpdateButtons_LBX • (TIER-3) • (3)
(9) Local Templates • (TIER-3)

 4 – Template Type: Browse
  – – Procedure Name: JumpStartManagePreBuiltQueriesIsam()
Count Local Template Name Qty Local Template Description
(0031) BrowseBox(ABC) 1 Browse on PreQueries ()
(0032) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on PreQueries
(0033) CloseButton(ABC) 1 Close the Window
(0034) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0035) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0036) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0037) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0038) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0039) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(0040) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) Local Templates • (TIER-3)

 5 – Template Type: Window
  – – Procedure Name: LBX_4_ListBoxBrowseExtenderPopFavoriteQueries()
Count Local Template Name Qty Local Template Description
(0041) CloseButton(ABC) 1 Close the Window
(0042) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (7)
(0043) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0044) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0045) ListBoxBrowseExtender(HNDTools) 1 © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (1)
(0046) MaxPreLoadRecordControl_LBX(HNDTools) 1 © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (9)
(0047) PopFavoriteQueries_LBX(HNDTools) 1 © CHT PopFavoriteQueries_LBX • (TIER-3) •
(0048) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0049) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(0050) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) Local Templates • (TIER-3)

 6 – Template Type: Window
  – – Procedure Name: LBX_2_ListBoxBrowseExtenderSortOrderFieldFilter()
Count Local Template Name Qty Local Template Description
(0051) CloseButton(ABC) 1 Close the Window
(0052) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (12)
(0053) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0054) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0055) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0056) ListBoxBrowseExtender(HNDTools) 1 © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (1)
(0057) MaxPreLoadRecordControl_LBX(HNDTools) 1 © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (11)
(0058) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0059) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(0060) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(0061) SortOrderFieldFilter_LBX(HNDTools) 1 © CHT SortOrderFieldFilter_LBX • (TIER-3) •
(11) Local Templates • (TIER-3)

 7 – Template Type: Splash
  – – Procedure Name: JumpStartSplash07()
Count Local Template Name Qty Local Template Description
(0062) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp • (TIER-2) •
(0063) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp • (TIER-2) •
(0064) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp • (TIER-2) •
(0065) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0066) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl • (TIER-2) • (2)
(0067) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0068) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(7) Local Templates • (TIER-3)

 8 – Template Type: Window
  – – Procedure Name: LBX_3_ListBrowseExtenderUniversalQueryControl()
Count Local Template Name Qty Local Template Description
(0069) CloseButton(ABC) 1 Close the Window
(0070) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (7)
(0071) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0072) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0073) ListBoxBrowseExtender(HNDTools) 1 © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (1)
(0074) MaxPreLoadRecordControl_LBX(HNDTools) 1 © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (11)
(0075) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0076) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(0077) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(0078) UniversalQueryControl_LBX(HNDTools) 1 © CHT UniversalQueryControl_LBX • (TIER-3) • (8)
(10) Local Templates • (TIER-3)

 9 – Template Type: ListBoxBrowseExtenderClientServerBrowse
  – – Procedure Name: LBX_6_ListBoxBrowseExtenderConditionalIconsTwoColumns()
Count Local Template Name Qty Local Template Description
(0079) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0080) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0081) ListBoxBrowseExtender(HNDTools) 1 © CHT ListboxBrowseExtender • (TIER-3) • (CODE-TABS) • (1)
(0082) MaxPreLoadRecordControl_LBX(HNDTools) 1 © CHT MaxPreLoadRecordControl_LBX • (TIER-3) • (9)
(0083) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0084) ResizeHandlesControl(HNDTools) 1 © CHT ResizeHandlesControl • (TIER-2) •
(0085) UniversalQueryControl_LBX(HNDTools) 1 © CHT UniversalQueryControl_LBX • (TIER-3) • (2)
(0086) UpdateButtons_LBX(HNDTools) 1 © CHT UpdateButtons_LBX • (TIER-3) • (3)
(8) 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