GENERATED: FEB 13,2021 - 5:39PM
SQL BROWSES EXPB_QRY [V10.21.02]

Previous Page

This is a CHT demo built with CHT templates and is roughly based on an SV demo application called SCHOOL.APP. It experiments specifically with the School-Classes table located in HNDSCHOOL.SQLITE. The SQLite Data tables are imported from the original TOPSPEED files provided with SV's SCHOOL.APP.

It uses the SQLite driver, the ABC browse template, CHT's EXPB browse extension, set to UseSQL=True and CHT's QPFC query template.

To analyse the allocation of templates in this application, open the application in the Clarion IDE and navigate to Global Extensions, select AACHTControlPanel and click on the menu item "Templates By Proc". This sequence of actions triggers an HTML document to display which enumerates and names all templates used in the application by procedure.

We chose to apply, as always, our "minimalist" screen design which avoids unnecessary use of tab controls, and shuns MDI child windows. Control buttons are for the most part kept to the toolbar and when placed on a window are always above the edit fields or list box.

CHT TEMPLATES LEGEND:
EXPB = ExplorerBrowse
QPFC = QueryParsingFilterControl

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: Window
EXAMPLE_3_ABC_PLUS_EXPB_PLUS_QPFC ()
Count Local Template Name Qty Local Template Description
(0008) BrowseBox(ABC) 1 Browse on Classes ()
(0009) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0010) CloseButton(ABC) 1 Close the Window
(0011) ExplorerBrowse(HNDTools) 1 © CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Classes
(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) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0015) QueryParsingFilterControl(HNDTools) 1 © CHT QueryParsingFilterControl - HBrw4 An Instance Of: HNDBrwFilter
(0016) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(0017) SetExplorerBrowseQueryBuilderBindings(HNDTools) 1 © CHT SetExplorerBrowseQueryBuilderBindings - Query field bindings for CHT Query Builder in the cont
(10) Local Templates Found In EXAMPLE_3_ABC_PLUS_EXPB_PLUS_QPFC

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

3 - Procedure Template Type: Window
EXAMPLE_6_ABC_PLUS_EXPB_PLUS_LCEX ()
Count Local Template Name Qty Local Template Description
(0023) BrowseBox(ABC) 1 Browse on Classes ()
(0024) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0025) CloseButton(ABC) 1 Close the Window
(0026) ExplorerBrowse(HNDTools) 1 © CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Classes
(0027) ExplorerBrowseLocatorControlEx(HNDTools) 1 © CHT ExplorerBrowseLocatorControlEx - Attach an EXTENDED CHT locator control to your Clarion Handy
(0028) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0029) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0030) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0031) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(9) Local Templates Found In EXAMPLE_6_ABC_PLUS_EXPB_PLUS_LCEX

4 - Procedure Template Type: Window
EXAMPLE_4_ABC_PLUS_EXPB_PLUS_OCQC ()
Count Local Template Name Qty Local Template Description
(0032) BrowseBox(ABC) 1 Browse on Classes ()
(0033) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0034) CloseButton(ABC) 1 Close the Window
(0035) ExplorerBrowse(HNDTools) 1 © CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Classes
(0036) ExplorerBrowseOneColumnQueryControl(HNDTools) 2 © CHT ExplorerBrowseOneColumnQueryControl - Attach a CHT single column query control to your Clarion
(0037) ExplorerBrowseQueryGoButton(HNDTools) 1 © CHT ExplorerBrowseQueryGoButton - A query "Go" button to accompany ExplorerBrowse.
(0038) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0039) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0040) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0041) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(10) Local Templates Found In EXAMPLE_4_ABC_PLUS_EXPB_PLUS_OCQC

5 - Procedure Template Type: Window
EXAMPLE_5_ABC_PLUS_EXPB_QBC ()
Count Local Template Name Qty Local Template Description
(0042) BrowseBox(ABC) 1 Browse on Classes ()
(0043) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0044) CloseButton(ABC) 1 Close the Window
(0045) ExplorerBrowse(HNDTools) 1 © CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Classes
(0046) ExplorerBrowseQueryBuilderControl(HNDTools) 1 © CHT ExplorerBrowseQueryBuilderControl - Attach a CHT Query Builder control to your Clarion Handy T
(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) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0050) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(0051) SetExplorerBrowseQueryBuilderBindings(HNDTools) 1 © CHT SetExplorerBrowseQueryBuilderBindings - Query field bindings for CHT Query Builder in the cont
(10) Local Templates Found In EXAMPLE_5_ABC_PLUS_EXPB_QBC

6 - Procedure Template Type: Window
SelectTeachers (<LONG xTeacherID>), LONG, PROC
Count Local Template Name Qty Local Template Description
(0052) BrowseBox(ABC) 1 Browse on Teachers ()
(0053) HandyMarkerBrowse(HNDTools) 1 © CHT HandyMarkerBrowse - Explorer-like ABC browse with record marking on table: Teachers
(0054) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0055) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0056) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(5) Local Templates Found In SelectTeachers

7 - Procedure Template Type: Window
EXAMPLE_2_ABC_PLUS_EXPB ()
Count Local Template Name Qty Local Template Description
(0057) BrowseBox(ABC) 1 Browse on Classes ()
(0058) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0059) CloseButton(ABC) 1 Close the Window
(0060) ExplorerBrowse(HNDTools) 1 © CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Classes
(0061) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0062) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0063) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0064) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(8) Local Templates Found In EXAMPLE_2_ABC_PLUS_EXPB

8 - Procedure Template Type: Frame
Main ()
Count Local Template Name Qty Local Template Description
(0065) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin An Instance Of: HNDWindow
(0066) HandyHelpFileFetch(HNDTools) 1 © CHT HandyHelpFileFetch - Build A Help File Request To Your Website.(7)
(0067) HandyHelpWhatsNew(HNDTools) 1 © CHT HandyHelpWhatsNew - Build A What's New Request To Your Website.(3)
(0068) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0069) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(5) Local Templates Found In Main

9 - Procedure Template Type: Window
SelectCourses (<LONG xCourseID>), LONG, PROC
Count Local Template Name Qty Local Template Description
(0070) BrowseBox(ABC) 1 Browse on Courses ()
(0071) HandyMarkerBrowse(HNDTools) 1 © CHT HandyMarkerBrowse - Explorer-like ABC browse with record marking on table: Courses
(0072) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0073) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0074) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(5) Local Templates Found In SelectCourses

10 - Procedure Template Type: Window
EXAMPLE_1_ABC_ALONE ()
Count Local Template Name Qty Local Template Description
(0075) BrowseBox(ABC) 1 Browse on Classes ()
(0076) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0077) CloseButton(ABC) 1 Close the Window
(0078) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0079) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0080) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0081) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(7) Local Templates Found In EXAMPLE_1_ABC_ALONE

11 - Procedure Template Type: Window
UpdateClassesTable (<LONG xInstructorID>)
Count Local Template Name Qty Local Template Description
(0082) CancelButton(ABC) 1 Cancel the Current Operation
(0083) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0084) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0085) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0086) SaveButton(ABC) 1 Update Classes record on disk
(5) Local Templates Found In UpdateClassesTable

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

chtlogo001.gif
Application Templates