GENERATED: FEB 13,2021 - 5:39PM
BROWSES EXPB (SQL) [V10.21.02]

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 - CHT Global Control Panel (hndtools.tpl)
(0002) ApplicationImagesEx(HNDTools) 1 © CHT ApplicationImagesEx - Application Styling System
(0003) HNDCMPControlPanel(HNDTools) 1 © CHT PROJECT BUILDER SUPPORT - Interface to the CHT Project Builder.
(0004) HandyCodeSigningExtension(HNDTools) 1 © CHT HandyCodeSigningExtension - Application Code-Signing System
(0005) HandyVersionResource(HNDTools) 1 © CHT HandyVersionResource - Version Resource/Build Number Information To EXE
(0006) INIFile(HNDTools) 1 © CHT INIFile - .INI FIle and Registry extension classes - HNDIni - globally to your application.
(0007) VblFileNames(HNDTools) 1 © CHT VblFileNames - Incorporate variable file names and defaults into your app from the dictionary.
(7) Global Templates Found

1 - Procedure Template Type: Browse
JumpStartManagePreBuiltQueriesSQL ()
Count Local Template Name Qty Local Template Description
(0008) BrowseBox(ABC) 1 Browse on PreQueries ()
(0009) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on PreQueries
(0010) CloseButton(ABC) 1 Close the Window
(0011) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin An Instance Of: HNDWindow
(0012) ExplorerBrowse(HNDTools) 1 © CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: PreQueries
(0013) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0014) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0015) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0016) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(9) Local Templates Found In JumpStartManagePreBuiltQueriesSQL

2 - Procedure Template Type: Splash
JumpStartSplash06 ()
Count Local Template Name Qty Local Template Description
(0017) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0018) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp - An application build number or version stamp.
(0019) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp - An application copyright stamp.
(0020) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl - Text box control to provide a message or help text.
(0021) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(5) Local Templates Found In JumpStartSplash06

3 - Procedure Template Type: Window
CompanyUpdateForm ()
Count Local Template Name Qty Local Template Description
(0022) CancelButton(ABC) 1 Cancel the Current Operation
(0023) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin10 An Instance Of: HNDWindow
(0024) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0025) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0026) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0027) RecordValidation(ABC) 1 Validate a record against the dictionary
(0028) SaveButton(ABC) 1 Update Customers record on disk
(7) Local Templates Found In CompanyUpdateForm

4 - Procedure Template Type: Window
ExplorerBrowseWithPopFavoriteQueries_EXPB ()
Count Local Template Name Qty Local Template Description
(0029) BrowseBox(ABC) 1 Browse on Customers ()
(0030) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0031) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin11 An Instance Of: HNDWindow
(0032) ExplorerBrowse(HNDTools) 1 © CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Customers
(0033) HandyThreadLimiter(HNDTools) 1 © CHT HandyThreadLimiter - Limit threaded procedures to one instance.
(0034) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0035) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0036) PopFavoriteQueries_EXPB(HNDTools) 1 © CHT PopFavoriteQueries_EXPB - Pop up pre-built queries and macros - a companion for Explorerbrowse
(0037) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0038) ResizeHandles(HNDTools) 1 © CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(0039) SetExplorerBrowseQueryBuilderBindings(HNDTools) 1 © CHT SetExplorerBrowseQueryBuilderBindings - Query field bindings for CHT Query Builder in the cont
(11) Local Templates Found In ExplorerBrowseWithPopFavoriteQueries_EXPB

5 - Procedure Template Type: Source
RegisterODBC ()
Count Local Template Name Qty Local Template Description
(0040) EmbedObject(HNDTools) 2 © CHT EmbedObject - HDisk An Instance Of: HNDDisk
(1) Local Templates Found In RegisterODBC

6 - Procedure Template Type: Frame
MainEntryPoint ()
Count Local Template Name Qty Local Template Description
(0041) EmbedDiskFunctions(HNDTools) 1 © CHT EmbedDiskFunctions - Disk Functions Classes - HDisk An Instance Of: HNDDisk
(0042) EmbedRegistryFunctions(HNDTools) 1 © CHT EmbedRegistryFunctions - HReg An Instance Of: HNDRegistry
(0043) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin An Instance Of: HNDWindow
(0044) HandyHelpFileFetch(HNDTools) 2 © CHT HandyHelpFileFetch - Build A Help File Request To Your Website.(7)
(0045) HandyHelpWhatsNew(HNDTools) 1 © CHT HandyHelpWhatsNew - Build A What's New Request To Your Website.(8)
(0046) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(6) Local Templates Found In MainEntryPoint

Copyright © 1996-2021 - CHT Version: [25A.01.00]
Gus M. Creces, CHT - Clarion Handy Tools
All Rights Reserved Worldwide

chtlogo001.gif
Application Templates