GENERATED: MAY 4,2023 - 8:56AM
BROWSES EXPB (SQL) [V10.23.04. 27.03]

Previous Page
This application demonstrates CHT Explorerbrowse used in an SQL setting. It illustrates these concepts:

•  BRWSQL1_ExplorerBrowse •  - CHT Query Builder in return-SQL mode populated with Explorerbrowse.

•  BRWSQL2_ExplorerBrowse •  - EXPB Locator ControlEx in drill-down mode.

•  Hiding/unhiding columns programmatically.
•  Hidden columns also hidden in CHT Query Builder.
•  SQL Tracing set to ON in both browses, trace with HNDSQLTRACE.EXE.

This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. The application will find the data base and register it with ODBC if not already registered.


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: CompanyUpdateForm()
Count Local Template Name Qty Local Template Description
(0007) CancelButton(ABC) 1 Cancel the Current Operation
(0008) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0009) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0010) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0011) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0012) RecordValidation(ABC) 1 Validate a record against the dictionary
(0013) SaveButton(ABC) 1 Update Customers record on disk
(7) Local Templates • (TIER-2)

 2 – Template Type: Window
  – – Procedure Name: BRWSQL2_ExplorerBrowse()
Count Local Template Name Qty Local Template Description
(0014) BrowseBox(ABC) 1 Browse on Customers ()
(0015) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0016) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0017) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0018) ExplorerBrowseLocatorControlEx(HNDTools) 1 ©  CHT ExplorerBrowseLocatorControlEx • (TIER-1) • (6)
(0019) ExplorerBrowseQueryBuilderControl(HNDTools) 1 ©  CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (3)
(0020) HandyQueryTracingButton_EXPB(HNDTools) 1 ©  button that enables flexible query tracing on CHT ExplorerBrowse
(0021) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0022) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0023) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0024) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(11) Local Templates • (TIER-2)

 3 – Template Type: Window
  – – Procedure Name: BRWSQL1_ExplorerBrowse()
Count Local Template Name Qty Local Template Description
(0025) BrowseBox(ABC) 1 Browse on Customers ()
(0026) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0027) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (8)
(0028) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0029) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0030) ExplorerBrowseQueryBuilderControl(HNDTools) 1 ©  CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (3)
(0031) HandyQueryTracingButton_EXPB(HNDTools) 1 ©  button that enables flexible query tracing on CHT ExplorerBrowse
(0032) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0033) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0034) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0035) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(11) Local Templates • (TIER-2)

 4 – Template Type: Frame
  – – Procedure Name: MainEntryPoint()
Count Local Template Name Qty Local Template Description
(0036) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (7)
(0037) EmbedDiskFunctions(HNDTools) 1 © CHT EmbedDiskFunctions • (TIER-2) •
(0038) EmbedRegistryFunctions(HNDTools) 1 © CHT EmbedRegistryFunctions • (TIER-2) •
(0039) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0040) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(5) Local Templates • (TIER-2)

 5 – Template Type: Splash
  – – Procedure Name: JumpStartSplashSea()
Count Local Template Name Qty Local Template Description
(0041) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp • (TIER-2) •
(0042) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp • (TIER-2) •
(0043) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp • (TIER-2) •
(0044) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0045) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl • (TIER-2) • (2)
(0046) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(6) 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