GENERATED: FEB 13,2021 - 5:38PM
BLADEREN DOOR HMB (SQL) [V10.21.02]

Previous Page
Deze applicatie toont CHT HandyMarkerBrowse gebruikt in een SQL-instelling. Het illustreert deze concepten:

•  SQLFilter_HandyMarkerBrowse •  - Illustreert een met de hand gebouwde SQL-querybesturingselement met behulp van een standaardvermeldingsbeheer dat is gecodeerd om een SQL-query in de gegevenstabel te plaatsen.

•  Verbergen / verbergen kolommen programmatisch.
•  SQL Query-injectie van een knop klik gebeurtenis
•  SQL Query tracing in en uit van een knop klik gebeurtenis

Deze demonstratietoepassing vereist de voorbeeldgegevensbank die is voorzien van MICROSOFT ACCESS, genaamd Northwind. De applicatie vindt de databank en registreert deze bij ODBC als deze nog niet is geregistreerd.


Count Global Template Name Qty Global Template Description
(0001) AACHTControlPanel(HNDTools) 1 © CHT AACHTControlPanel - CHT Global Control Panel (hndtools.tpl)
(0002) AACHTControlPanelClose(HNDTools) 1 © CHT AACHTControlPanelClose - Global Control Panel (Close).
(0003) ApplicationImagesEx(HNDTools) 1 © CHT ApplicationImagesEx - Application Styling System
(0004) GlobalTransparentControls(HNDTools) 1 © CHT GlobalTransparentControls - Globally Add Transparency To Your Window/Report Controls
(0005) HNDCMPControlPanel(HNDTools) 1 © CHT PROJECT BUILDER SUPPORT - Interface to the CHT Project Builder.
(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: Window
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 - HWin11 An Instance Of: HNDWindow
(0013) HandyMarkerBrowse(HNDTools) 1 © CHT HandyMarkerBrowse - Explorer-like ABC browse with record marking on table: Customers
(0014) HandyMarkerBrowseQueryBuilderControl(HNDTools) 1 © CHT HandyMarkerBrowseQueryBuilderControl - Attach a CHT Query Builder control to your Clarion Hand
(0015) HandyQueryTracingButton_HMB(HNDTools) 1 © CHT HandyQueryTracingButton_HMB - A button that enables flexible query tracing on CHT HandyMarkerB
(0016) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0017) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0018) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0019) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(10) Local Templates Found In SQLFilter_HandyMarkerBrowse

2 - Procedure Template Type: Source
RegisterODBC ()
Count Local Template Name Qty Local Template Description
(0020) EmbedObject(HNDTools) 2 © CHT EmbedObject - HDisk An Instance Of: HNDDisk
(0021) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(2) Local Templates Found In RegisterODBC

3 - Procedure Template Type: Splash
JumpStartSplash07 ()
Count Local Template Name Qty Local Template Description
(0022) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0023) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp - An application build number or version stamp.
(0024) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp - An application copyright stamp.
(0025) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl - Text box control to provide a message or help text.
(0026) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0027) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(6) Local Templates Found In JumpStartSplash07

4 - Procedure Template Type: Window
UpdateForm ()
Count Local Template Name Qty Local Template Description
(0028) CancelButton(ABC) 1 Cancel the Current Operation
(0029) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin10 An Instance Of: HNDWindow
(0030) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0031) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0032) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0033) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0034) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(0035) RecordValidation(ABC) 1 Validate a record against the dictionary
(0036) SaveButton(ABC) 1 Update Customers record on disk
(9) Local Templates Found In UpdateForm

5 - Procedure Template Type: Splash
JumpStartSplash06 ()
Count Local Template Name Qty Local Template Description
(0037) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0038) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp - An application build number or version stamp.
(0039) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp - An application copyright stamp.
(0040) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl - Text box control to provide a message or help text.
(0041) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0042) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(6) Local Templates Found In JumpStartSplash06

6 - Procedure Template Type: Frame
MainEntryPoint ()
Count Local Template Name Qty Local Template Description
(0043) EmbedDiskFunctions(HNDTools) 1 © CHT EmbedDiskFunctions - Disk Functions Classes - HDisk An Instance Of: HNDDisk
(0044) EmbedRegistryFunctions(HNDTools) 1 © CHT EmbedRegistryFunctions - HReg An Instance Of: HNDRegistry
(0045) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions - HWin An Instance Of: HNDWindow
(0046) HandyHelpFileFetch(HNDTools) 6 © CHT HandyHelpFileFetch - Build A Help File Request To Your Website.(12)
(0047) HandyHelpWhatsNew(HNDTools) 1 © CHT HandyHelpWhatsNew - Build A What's New Request To Your Website.(8)
(0048) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx - Application Styling System
(0049) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls - Set Transparency To Your Procedure Window/Report Controls
(7) 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