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

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

•  A CHT ExplorerBrowse Template.

•  A CHT ExplorerBrowseQueryBuilder Template.

•  A CHT PopFavoriteQueries_EXPB Template.

•  A CHT ExplorerBrowseLocatorControlEx Template.

•  A CHT ExplorerBrowseOneColumnQueryControl Template.

•  A CHT Explorerbrowse range-limiting query example.

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) FieldLevelValidationCode(HNDTools) 1 © CHT FieldLevelValidationCode • (TIER-1) •
(0004) GlobalIncludeHNDDiskFunctions(HNDTools) 1 © CHT GlobalIncludeHNDDiskFunctions • (TIER-2) •
(0005) GlobalTransparentControls(HNDTools) 1 © CHT GlobalTransparentControls (TIER-1)
(0006) HNDCMPControlPanel(HNDTools) 1 © CHT HNDCMPControlPanel • (TIER-2) •
(0007) HandyVersionResource(HNDTools) 1 © CHT HandyVersionResource • (TIER-1) •
(0008) INIFile(HNDTools) 1 © CHT INIFile • (TIER-1) •
(0009) VblFileNames(HNDTools) 1 © CHT VblFileNames • (TIER-1) •
(9) Global Templates • (TIER-2)

 1 – Template Type: Splash
  – – Procedure Name: JumpStartSplash06()
Count Local Template Name Qty Local Template Description
(0010) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp • (TIER-2) •
(0011) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp • (TIER-2) •
(0012) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp • (TIER-2) •
(0013) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0014) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl • (TIER-2) • (2)
(0015) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0016) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(7) Local Templates • (TIER-2)

 2 – Template Type: Frame
  – – Procedure Name: MainEntryPoint()
Count Local Template Name Qty Local Template Description
(0017) EmbedRegistryFunctions(HNDTools) 1 © CHT EmbedRegistryFunctions • (TIER-2) •
(0018) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0019) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0020) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(4) Local Templates • (TIER-2)

 3 – Template Type: Window
  – – Procedure Name: SQLFilter_ExplorerBrowse()
Count Local Template Name Qty Local Template Description
(0021) BrowseBox(ABC) 1 Browse on Customers ()
(0022) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0023) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0024) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0025) ExplorerBrowseLocatorControlEx(HNDTools) 1 ©  CHT ExplorerBrowseLocatorControlEx • (TIER-1) • (10)
(0026) ExplorerBrowseOneColumnQueryControl(HNDTools) 1 ©  CHT ExplorerBrowseOneColumnQueryControl • (TIER-1) • (13)
(0027) ExplorerBrowseQueryBuilderControl(HNDTools) 1 ©  CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (3)
(0028) ExplorerBrowseQueryGoButton(HNDTools) 1 ©  CHT ExplorerBrowseQueryGoButton • (TIER-1) •
(0029) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0030) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0031) PopFavoriteQueries_EXPB(HNDTools) 1 ©  CHT PopFavoriteQueries_EXPB • (TIER-1) • (CODE-TABS) •
(0032) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0033) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(0034) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(14) Local Templates • (TIER-2)

 4 – Template Type: Window
  – – Procedure Name: ABCUpdateForm()
Count Local Template Name Qty Local Template Description
(0035) CancelButton(ABC) 1 Cancel the Current Operation
(0036) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0037) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0038) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0039) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0040) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0041) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(0042) RecordValidation(ABC) 1 Validate a record against the dictionary
(0043) SaveButton(ABC) 1 Update Customers record on disk
(9) Local Templates • (TIER-2)

 5 – Template Type: Browse
  – – Procedure Name: ManagePreBuiltQueries()
Count Local Template Name Qty Local Template Description
(0044) BrowseBox(ABC) 1 Browse on PreQueries ()
(0045) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on PreQueries
(0046) CloseButton(ABC) 1 Close the Window
(0047) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0048) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0049) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0050) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0051) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0052) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(0053) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) 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