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. |
PROCEDURE (1): Main (Procedure Template: Frame) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0002) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0003) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(3) Class Instances Found In Main | |||||
PROCEDURE (2): LBX_1_ListBoxBrowseExtenderInQueueQuery (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | ListBox | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles6 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In LBX_1_ListBoxBrowseExtenderInQueueQuery | |||||
PROCEDURE (3): LBX_5_ListBoxBrowseExtenderConditionalIconsOneColumn (Procedure Template: ListBoxBrowseExtenderClientServerBrowse) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | LBX1 | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles4 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In LBX_5_ListBoxBrowseExtenderConditionalIconsOneColumn | |||||
PROCEDURE (4): JumpStartManagePreBuiltQueriesIsam (Procedure Template: Browse) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | BRW1 | BrowseClass | ABC | 85 | ABBROWSE.INC |
(0002) | BRW1::EIPManager | BrowseEIPManager | ABC | 47 | ABBROWSE.INC |
(0003) | EditInPlace::PRQ:Description | EditEntryClass | ABC | 9 | ABEIP.INC |
(0004) | EditInPlace::PRQ:ViewName | EditEntryClass | ABC | 9 | ABEIP.INC |
(0005) | EditInPlace::PRQ:ViewQuery | EditEntryClass | ABC | 9 | ABEIP.INC |
(0006) | HBrw6 | HNDBrowse | HND | 432 | HNDBROWS.INC |
(0007) | HSizes6 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0008) | Handles7 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0009) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0010) | BRW1::Sort0:Locator | StepLocatorClass | ABC | 12 | ABBROWSE.INC |
(0011) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0012) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(12) Class Instances Found In JumpStartManagePreBuiltQueriesIsam | |||||
PROCEDURE (5): LBX_4_ListBoxBrowseExtenderPopFavoriteQueries (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | ListBox | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles6 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In LBX_4_ListBoxBrowseExtenderPopFavoriteQueries | |||||
PROCEDURE (6): LBX_2_ListBoxBrowseExtenderSortOrderFieldFilter (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | ListBox | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles6 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In LBX_2_ListBoxBrowseExtenderSortOrderFieldFilter | |||||
PROCEDURE (7): JumpStartSplash07 (Procedure Template: Splash) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | HTellMe | HNDWindow | HND | 206 | HNDWINDO.INC |
(0002) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0003) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0004) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(4) Class Instances Found In JumpStartSplash07 | |||||
PROCEDURE (8): LBX_3_ListBrowseExtenderUniversalQueryControl (Procedure Template: Window) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | ListBox | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles6 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In LBX_3_ListBrowseExtenderUniversalQueryControl | |||||
PROCEDURE (9): LBX_6_ListBoxBrowseExtenderConditionalIconsTwoColumns (Procedure Template: ListBoxBrowseExtenderClientServerBrowse) |
|||||
Count | Instance | Class | Type | Methods | Header File |
(0001) | LBX1 | HNDFileLoadBrowse | HND | 448 | HNDFLBRW.INC |
(0002) | Handles4 | HNDSizes | HND | 23 | HNDSIZES.INC |
(0003) | HWin | HNDWindow | HND | 206 | HNDWINDO.INC |
(0004) | Toolbar | ToolbarClass | ABC | 6 | ABTOOLBA.INC |
(0005) | ThisWindow | WindowManager | ABC | 40 | ABWINDOW.INC |
(5) Class Instances Found In LBX_6_ListBoxBrowseExtenderConditionalIconsTwoColumns | |||||