GENERATED: JUL 11,2017 - 12:13AM
ExplorerBrowse SQL Query Demo [V10.17.05.0223]

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

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.

Cheers,
Gus M. Creces
The Clarion Handy Tools Page
www.cwhandy.ca (CHT Website)
news.cwhandy.ca (CHT Forum)

Count Global Template Name Qty Global Template Description
(0001) AACHTControlPanel(HNDTools) 1 CHT AACHTControlPanel - Global Control Panel.
(0002) ApplicationImagesEx(HNDTools) 1 CHT ApplicationImagesEx - Application Styling System
(0003) FieldLevelValidationCode(HNDTools) 1 CHT FieldLevelValidationCode - Inserts field level validation code directly from your dictionary.
(0004) GlobalTransparentControls(HNDTools) 1 CHT GlobalTransparentControls - Globally Add Transparency To Your Window/Report Controls
(0005) HNDCMPControlPanel(HNDTools) 1 CHT HNDCMPControlPanel - Interface to the CHT Compile Manager.
(0006) HandyCodeSigningExtension(HNDTools) 1 CHT HandyCodeSigningExtension - Application Code-Signing System
(0007) HandyVersionResource(HNDTools) 1 CHT HandyVersionResource - Version Resource/Build Number Information To EXE
(0008) INIFile(HNDTools) 1 CHT INIFile - .INI FIle and Registry extension classes - HNDIni - globally to your application.
(0009) VblFileNames(HNDTools) 1 CHT VblFileNames - Incorporate variable file names and defaults into your app from the dictionary.
(9) Global Templates Found

1 - Procedure Template Type: Splash
JumpStartSplashCHTBlue ()
Count Local Template Name Qty Local Template Description
(0010) AppBuildDateTimeStamp(HNDTools) 1 CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0011) AppBuildNumberStamp(HNDTools) 1 CHT AppBuildNumberStamp - An application build number or version stamp.
(0012) AppCopyRightStamp(HNDTools) 1 CHT AppCopyRightStamp - An application copyright stamp.
(0013) HandyTellMeControl(HNDTools) 1 CHT HandyTellMeControl - Text box control to provide a message or help text.
(0014) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0015) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(6) Local Templates Found In JumpStartSplashCHTBlue

2 - Procedure Template Type: Frame
MainEntryPoint ()
Count Local Template Name Qty Local Template Description
(0016) EmbedDiskFunctions(HNDTools) 1 CHT EmbedDiskFunctions - Disk Functions Classes - An Instance Of:
(0017) EmbedRegistryFunctions(HNDTools) 1 CHT EmbedRegistryFunctions - An Instance Of:
(0018) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0019) HandyHelpFileFetch(HNDTools) 5 CHT HandyHelpFileFetch - Build A Help File Request To Your Website.(11)
(0020) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0021) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(6) Local Templates Found In MainEntryPoint

3 - Procedure Template Type: Window
SQLFilter_ExplorerBrowse ()
Count Local Template Name Qty Local Template Description
(0022) BrowseBox(ABC) 1 Browse on Customers ()
(0023) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0024) EmbedInformation(HNDTools) 1 CHT EmbedInformation - Code template to generate embed information.(16)
(0025) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0026) ExplorerBrowse(HNDTools) 1 CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Customers
(0027) ExplorerBrowseLocatorControlEx(HNDTools) 1 CHT ExplorerBrowseLocatorControlEx - Attach an EXTENDED CHT locator control to your Clarion Handy Tools ExplorerBrowse procedure.(10)
(0028) ExplorerBrowseOneColumnQueryControl(HNDTools) 1 CHT ExplorerBrowseOneColumnQueryControl - Attach a CHT single column query control to your Clarion Handy Tools ExplorerBrowse procedure.(13)
(0029) ExplorerBrowseQueryBuilderControl(HNDTools) 1 CHT ExplorerBrowseQueryBuilderControl - Attach a CHT Query Builder control to your Clarion Handy Tools ExplorerBrowse procedure.(3)
(0030) ExplorerBrowseQueryGoButton(HNDTools) 1 CHT ExplorerBrowseQueryGoButton - A query "Go" button to accompany ExplorerBrowse.
(0031) HandyThreadLimiter(HNDTools) 1 CHT HandyThreadLimiter - Limit threaded procedures to one instance.
(0032) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0033) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0034) PopFavoriteQueries_EXPB(HNDTools) 1 CHT PopFavoriteQueries_EXPB - Pop up pre-built queries and macros - a companion for Explorerbrowse.
(0035) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0036) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(0037) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(16) Local Templates Found In SQLFilter_ExplorerBrowse

4 - Procedure Template Type: Window
ABCUpdateForm ()
Count Local Template Name Qty Local Template Description
(0038) CancelButton(ABC) 1 Cancel the Current Operation
(0039) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0040) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0041) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0042) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0043) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0044) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(0045) RecordValidation(ABC) 1 Validate a record against the dictionary
(0046) SaveButton(ABC) 1 Update Customers record on disk
(9) Local Templates Found In ABCUpdateForm

5 - Procedure Template Type: Source
RegisterODBC ()
Count Local Template Name Qty Local Template Description
(0047) EmbedObject(HNDTools) 2 CHT EmbedObject - An Instance Of:
(0048) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(2) Local Templates Found In RegisterODBC

6 - Procedure Template Type: Browse
ManagePreBuiltQueries ()
Count Local Template Name Qty Local Template Description
(0049) BrowseBox(ABC) 1 Browse on PreQueries ()
(0050) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on PreQueries
(0051) CloseButton(ABC) 1 Close the Window
(0052) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0053) ExplorerBrowse(HNDTools) 1 CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: PreQueries
(0054) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0055) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0056) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0057) ProcedureTransparentControls(HNDTools) 1 CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(0058) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(10) Local Templates Found In ManagePreBuiltQueries

Copyright © 1996-2017 - CHT Version: [21C.00.00]
Gus M. Creces and The Clarion Handy Tools Page.
All Rights Reserved Worldwide

chtlogo001.gif Templates In Application: HNDSQL3.APP