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

Previous Page

This application demonstrates CHT Explorerbrowse used in an SQL setting in conjunction with query template PopFavoriteQueries_EXPB (PFQ_EXPB)

It illustrates these concepts:
• • •  An Explorerbrowse implementation running
on SQL Data Tables.
• • •  CHT Query template PopFavoriteQueries_EXPB
• • •  Default query applied on browse opening
is under user, run-time control
• • •  Concatentaion of two fields (TELEPHONE + FAX)
in a single column
• • •  TELEPHONE and FAX are individually queryable
from PFQ_EXPB
• • •  SetExplorerBrowseQueryBindings - enables
querying of fields not individually displayed
in the browse. for example: FAX

This demonstration application requires the sample data tables provided with MICROSOFT ACCESS, called Northwind. The CHT toolkit installs these Northwind tables for you. The application finds these tables and registers them with ODBC if not already registered when you first run this demo app.

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: Browse
  – – Procedure Name: JumpStartManagePreBuiltQueriesSQL()
Count Local Template Name Qty Local Template Description
(0007) BrowseBox(ABC) 1 Browse on PreQueries ()
(0008) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on PreQueries
(0009) CloseButton(ABC) 1 Close the Window
(0010) CodeTabEventHooks(HNDTools) 1 © CHT CodeTabEventHooks • (TIER-1 • (CODE-TABS) • (5)
(0011) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0012) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0013) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0014) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0015) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0016) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) Local Templates • (TIER-2)

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

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

 4 – Template Type: Window
  – – Procedure Name: ExplorerBrowseWithPopFavoriteQueries_EXPB()
Count Local Template Name Qty Local Template Description
(0030) BrowseBox(ABC) 1 Browse on Customers ()
(0031) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0032) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0033) ExplorerBrowse(HNDTools) 1 ©  CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) •
(0034) HandyThreadLimiter(HNDTools) 1 © CHT HandyThreadLimiter • (TIER-1) •
(0035) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0036) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0037) PopFavoriteQueries_EXPB(HNDTools) 1 ©  CHT PopFavoriteQueries_EXPB • (TIER-1) • (CODE-TABS) •
(0038) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0039) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(0040) SetExplorerBrowseQueryBuilderBindings(HNDTools) 1 ©  CHT SetExplorerBrowseQueryBuilderBindings • (TIER-1) • (6)
(11) Local Templates • (TIER-2)

 5 – Template Type: Frame
  – – Procedure Name: MainEntryPoint()
Count Local Template Name Qty Local Template Description
(0041) EmbedDiskFunctions(HNDTools) 1 © CHT EmbedDiskFunctions • (TIER-2) •
(0042) EmbedRegistryFunctions(HNDTools) 1 © CHT EmbedRegistryFunctions • (TIER-2) •
(0043) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0044) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(4) 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