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

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

•  SQLFilter_HandyMarkerBrowse •  - Illustrates a hand-built SQL query control using a standard entry control coded to post an SQL query to the data table.

•  Hiding/unhiding columns programmatically.
•  SQL Query injection from a button click event
•  SQL Query tracing on and off from a button click event
•  AppendSQLFilter manual append to SQL queries
•  HandyMarkerBrowse Locator Control with filtering ON

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) AACHTControlPanelClose(HNDTools) 1 © CHT AACHTControlPanelClose • (TIER-1) •
(0003) ApplicationImagesEx(HNDTools) 1 © CHT ApplicationImagesEx • (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: Window
  – – Procedure Name: SQLFilter_HandyMarkerBrowse()
Count Local Template Name Qty Local Template Description
(0010) BrowseBox(ABC) 1 Browse on Customers ()
(0011) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0012) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0013) HandyEmbedFromTemplateButton(HNDTools) 2 © CHT HandyEmbedFromTemplateButton • (TIER-1) • (CODE-TABS) • (4)
(0014) HandyMarkerBrowse(HNDTools) 1 © CHT HandyMarkerBrowse • (TIER-1) • (CODE-TABS) • (5)
(0015) HandyMarkerBrowseLocatorControl(HNDTools) 1 © CHT HandyMarkerBrowseLocatorControl • (TIER-1) • (2)
(0016) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0017) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0018) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(9) Local Templates • (TIER-2)

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

 3 – Template Type: Splash
  – – Procedure Name: JumpStartSplash06()
Count Local Template Name Qty Local Template Description
(0028) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp • (TIER-2) •
(0029) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp • (TIER-2) •
(0030) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp • (TIER-2) •
(0031) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0032) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl • (TIER-2) • (2)
(0033) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0034) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(7) Local Templates • (TIER-2)

 4 – Template Type: Frame
  – – Procedure Name: MainEntryPoint()
Count Local Template Name Qty Local Template Description
(0035) CodeTabMenuHooks(HNDTools) 1 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (2)
(0036) EmbedRegistryFunctions(HNDTools) 1 © CHT EmbedRegistryFunctions • (TIER-2) •
(0037) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0038) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0039) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(5) 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