GENERATED: MAY 4,2023 - 8:32AM
BROWSES EXPB (SQL) [V23.04.30. 27.03]

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

•  BRWSQLA_ExplorerBrowse_Grey •  - ExplorerBrowse Locator ControlEx in drill-down mode.

•  BRWSQLB_ExplorerBrowse_Red •  - ExplorerBrowse Locator ControlEx in drill-down mode.

•  BRWSQLC_ExplorerBrowse_Green •  - ExplorerBrowse Locator ControlEx in drill-down mode.

•  BRWSQLD_ExplorerBrowse_Blue •  - ExplorerBrowse Locator ControlEx in drill-down mode.

•  Hiding/unhiding columns programmatically.
•  Hidden columns are hidden also in Query Builder.
•  SQL Tracing set to ON in all browses, trace with <13,10>- 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) GlobalIncludeHNDDiskFunctions(HNDTools) 1 © CHT GlobalIncludeHNDDiskFunctions • (TIER-2) •
(0004) HNDCMPControlPanel(HNDTools) 1 © CHT HNDCMPControlPanel • (TIER-2) •
(0005) HandyVersionResource(HNDTools) 1 © CHT HandyVersionResource • (TIER-1) •
(0006) INIFile(HNDTools) 1 © CHT INIFile • (TIER-1) •
(0007) VblFileNames(HNDTools) 1 © CHT VblFileNames • (TIER-1) •
(7) Global Templates • (TIER-2)

 1 – Template Type: Window
  – – Procedure Name: BRWSQLA_ExplorerBrowse_Grey()
Count Local Template Name Qty Local Template Description
(0008) BrowseBox(ABC) 1 Browse on Customers ()
(0009) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0010) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (6)
(0011) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0012) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0013) ExplorerBrowseQueryBuilderControl(HNDTools) 1 ©  CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (3)
(0014) HandyQueryTracingButton_EXPB(HNDTools) 1 ©  button that enables flexible query tracing on CHT ExplorerBrowse
(0015) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0016) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0017) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) Local Templates • (TIER-2)

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

 3 – Template Type: Window
  – – Procedure Name: CompanyUpdateForm()
Count Local Template Name Qty Local Template Description
(0028) CancelButton(ABC) 1 Cancel the Current Operation
(0029) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (6)
(0030) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0031) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0032) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0033) RecordValidation(ABC) 1 Validate a record against the dictionary
(0034) SaveButton(ABC) 1 Update Customers record on disk
(7) Local Templates • (TIER-2)

 4 – Template Type: IniTableIOProcedure
  – – Procedure Name: HNDIniIOProcedure()
Count Local Template Name Qty Local Template Description
() Local Templates • (TIER-2)

 5 – Template Type: Window
  – – Procedure Name: BRWSQLD_ExplorerBrowse_Blue()
Count Local Template Name Qty Local Template Description
(0035) BrowseBox(ABC) 1 Browse on Customers ()
(0036) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0037) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (8)
(0038) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0039) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0040) ExplorerBrowseQueryBuilderControl(HNDTools) 1 ©  CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (3)
(0041) HandyQueryTracingButton_EXPB(HNDTools) 1 ©  button that enables flexible query tracing on CHT ExplorerBrowse
(0042) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0043) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0044) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) Local Templates • (TIER-2)

 6 – Template Type: Window
  – – Procedure Name: BRWSQLB_ExplorerBrowse_Red()
Count Local Template Name Qty Local Template Description
(0045) BrowseBox(ABC) 1 Browse on Customers ()
(0046) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0047) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (4)
(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) • (3)
(0051) HandyQueryTracingButton_EXPB(HNDTools) 1 ©  button that enables flexible query tracing on CHT ExplorerBrowse
(0052) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0053) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0054) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) Local Templates • (TIER-2)

 7 – Template Type: Frame
  – – Procedure Name: MainEntryPoint()
Count Local Template Name Qty Local Template Description
(0055) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (2)
(0056) EmbedRegistryFunctions(HNDTools) 1 © CHT EmbedRegistryFunctions • (TIER-2) •
(0057) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0058) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(4) Local Templates • (TIER-2)

 8 – Template Type: Splash
  – – Procedure Name: JumpStartSplash06()
Count Local Template Name Qty Local Template Description
(0059) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp • (TIER-2) •
(0060) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp • (TIER-2) •
(0061) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp • (TIER-2) •
(0062) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0063) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl • (TIER-2) • (2)
(0064) 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