GENERATED: MAY 4,2023 - 8:39AM
SQL BROWSES EXPB_QRY [V10.23.04. 27.03]

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 • (TIER-1) •
(0002) ApplicationImagesEx(HNDTools) 1 © CHT ApplicationImagesEx • (TIER-1) •
(0003) HNDCMPControlPanel(HNDTools) 1 © CHT HNDCMPControlPanel • (TIER-2) •
(0004) HandyVersionResource(HNDTools) 1 © CHT HandyVersionResource • (TIER-1) •
(0005) INIFile(HNDTools) 1 © CHT INIFile • (TIER-1) •
(0006) VblFileNames(HNDTools) 1 © CHT VblFileNames • (TIER-1) •
(6) Global Templates • (TIER-2)

 1 – Template Type: Window
  – – Procedure Name: EXAMPLE_3_ABC_PLUS_EXPB_PLUS_QPFC()
Count Local Template Name Qty Local Template Description
(0007) BrowseBox(ABC) 1 Browse on Classes ()
(0008) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0009) CloseButton(ABC) 1 Close the Window
(0010) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0011) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0012) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0013) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0014) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0015) QueryParsingFilterControl(HNDTools) 1 © CHT QueryParsingFilterControl • (TIER-1 • (6)
(0016) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(0017) SetExplorerBrowseQueryBuilderBindings(HNDTools) 1 ©  CHT SetExplorerBrowseQueryBuilderBindings • (TIER-1) • (10)
(11) Local Templates • (TIER-2)

 2 – Template Type: Splash
  – – Procedure Name: JumpStartSplash07()
Count Local Template Name Qty Local Template Description
(0018) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp • (TIER-2) •
(0019) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp • (TIER-2) •
(0020) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp • (TIER-2) •
(0021) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0022) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl • (TIER-2) • (2)
(0023) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(6) Local Templates • (TIER-2)

 3 – Template Type: Window
  – – Procedure Name: EXAMPLE_6_ABC_PLUS_EXPB_PLUS_LCEX()
Count Local Template Name Qty Local Template Description
(0024) BrowseBox(ABC) 1 Browse on Classes ()
(0025) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0026) CloseButton(ABC) 1 Close the Window
(0027) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0028) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0029) ExplorerBrowseLocatorControlEx(HNDTools) 1 ©  CHT ExplorerBrowseLocatorControlEx • (TIER-1) • (6)
(0030) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0031) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0032) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0033) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) Local Templates • (TIER-2)

 4 – Template Type: Window
  – – Procedure Name: EXAMPLE_4_ABC_PLUS_EXPB_PLUS_OCQC()
Count Local Template Name Qty Local Template Description
(0034) BrowseBox(ABC) 1 Browse on Classes ()
(0035) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0036) CloseButton(ABC) 1 Close the Window
(0037) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0038) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0039) ExplorerBrowseOneColumnQueryControl(HNDTools) 2 ©  CHT ExplorerBrowseOneColumnQueryControl • (TIER-1) • (10)
(0040) ExplorerBrowseQueryGoButton(HNDTools) 1 ©  CHT ExplorerBrowseQueryGoButton • (TIER-1) •
(0041) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0042) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0043) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0044) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(11) Local Templates • (TIER-2)

 5 – Template Type: Window
  – – Procedure Name: EXAMPLE_5_ABC_PLUS_EXPB_QBC()
Count Local Template Name Qty Local Template Description
(0045) BrowseBox(ABC) 1 Browse on Classes ()
(0046) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0047) CloseButton(ABC) 1 Close the Window
(0048) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0049) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0050) ExplorerBrowseQueryBuilderControl(HNDTools) 1 ©  CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (6)
(0051) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0052) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0053) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0054) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(0055) SetExplorerBrowseQueryBuilderBindings(HNDTools) 1 ©  CHT SetExplorerBrowseQueryBuilderBindings • (TIER-1) • (10)
(11) Local Templates • (TIER-2)

 6 – Template Type: Window
  – – Procedure Name: SelectTeachers()
Count Local Template Name Qty Local Template Description
(0056) BrowseBox(ABC) 1 Browse on Teachers ()
(0057) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (7)
(0058) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0059) HandyMarkerBrowse(HNDTools) 1 © CHT HandyMarkerBrowse • (TIER-1) • (CODE-TABS) • (3)
(0060) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0061) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0062) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(7) Local Templates • (TIER-2)

 7 – Template Type: Window
  – – Procedure Name: EXAMPLE_2_ABC_PLUS_EXPB()
Count Local Template Name Qty Local Template Description
(0063) BrowseBox(ABC) 1 Browse on Classes ()
(0064) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0065) CloseButton(ABC) 1 Close the Window
(0066) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0067) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0068) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0069) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0070) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0071) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(9) Local Templates • (TIER-2)

 8 – Template Type: Frame
  – – Procedure Name: Main()
Count Local Template Name Qty Local Template Description
(0072) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (5)
(0073) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0074) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0075) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(4) Local Templates • (TIER-2)

 9 – Template Type: Window
  – – Procedure Name: SelectCourses()
Count Local Template Name Qty Local Template Description
(0076) BrowseBox(ABC) 1 Browse on Courses ()
(0077) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (7)
(0078) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0079) HandyMarkerBrowse(HNDTools) 1 © CHT HandyMarkerBrowse • (TIER-1) • (CODE-TABS) • (3)
(0080) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0081) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0082) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(7) Local Templates • (TIER-2)

 10 – Template Type: Window
  – – Procedure Name: EXAMPLE_1_ABC_ALONE()
Count Local Template Name Qty Local Template Description
(0083) BrowseBox(ABC) 1 Browse on Classes ()
(0084) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Classes
(0085) CloseButton(ABC) 1 Close the Window
(0086) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0087) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0088) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0089) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0090) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(8) Local Templates • (TIER-2)

 11 – Template Type: Window
  – – Procedure Name: UpdateClassesTable()
Count Local Template Name Qty Local Template Description
(0091) CancelButton(ABC) 1 Cancel the Current Operation
(0092) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (8)
(0093) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0094) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0095) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0096) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0097) SaveButton(ABC) 1 Update Classes record on disk
(7) Local Templates • (TIER-2)

Copyright © 1996-2023 - CHT Version: [27B.00.00]
Gus M. Creces, CLARION HANDY TOOLS
All Rights Reserved Worldwide

chtlogo001.gif
Application Templates