GENERATED: MAY 4,2023 - 8:31AM
BLADEREN DOOR HMB (SQL) [V23.04.30. 27.00]

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 • (TIER-1) •
(0002) AACHTControlPanelClose(HNDTools) 1 © CHT AACHTControlPanelClose • (TIER-1) •
(0003) ApplicationImagesEx(HNDTools) 1 © CHT ApplicationImagesEx • (TIER-1) •
(0004) GlobalTransparentControls(HNDTools) 1 © CHT GlobalTransparentControls ’ (TIER-1) ’
(0005) HNDCMPControlPanel(HNDTools) 1 © CHT HNDCMPControlPanel • (TIER-2) •
(0006) HandyVersionResource(HNDTools) 1 © CHT HandyVersionResource • (TIER-1) •
(0007) INIFile(HNDTools) 1 © CHT INIFile • (TIER-1) •
(0008) VblFileNames(HNDTools) 1 © CHT VblFileNames • (TIER-1) •
(8) Global Templates • (TIER-2)

 1 – Template Type: Window
  – – Procedure Name: SQLFilter_HandyMarkerBrowse()
Count Local Template Name Qty Local Template Description
(0009) BrowseBox(ABC) 1 Browse on Customers ()
(0010) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0011) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0012) HandyMarkerBrowse(HNDTools) 1 © CHT HandyMarkerBrowse • (TIER-1) • (CODE-TABS) • (5)
(0013) HandyMarkerBrowseQueryBuilderControl(HNDTools) 1 © CHT HandyMarkerBrowseQueryBuilderControl • (TIER-1) • (3)
(0014) HandyQueryTracingButton_HMB(HNDTools) 1 © CHT HandyQueryTracingButton_HMB • (TIER-1) • (2)
(0015) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0016) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0017) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(9) Local Templates • (TIER-2)

 2 – Template Type: Source
  – – Procedure Name: RegisterODBC()
Count Local Template Name Qty Local Template Description
(0018) EmbedDiskFunctions(HNDTools) 1 © CHT EmbedDiskFunctions • (TIER-2) •
(0019) EmbedObject(HNDTools) 1 © CHT EmbedObject • (TIER-4) • (3)
(0020) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(3) Local Templates • (TIER-4)

 3 – Template Type: Splash
  – – Procedure Name: JumpStartSplash07()
Count Local Template Name Qty Local Template Description
(0021) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp • (TIER-2) •
(0022) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp • (TIER-2) •
(0023) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp • (TIER-2) •
(0024) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0025) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl • (TIER-2) • (2)
(0026) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0027) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(7) Local Templates • (TIER-4)

 4 – Template Type: Window
  – – Procedure Name: UpdateForm()
Count Local Template Name Qty Local Template Description
(0028) CancelButton(ABC) 1 Cancel the Current Operation
(0029) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0030) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0031) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0032) HandyWindowGradient(HNDTools) 1 © CHT HandyWindowGradient • (TIER-2) •
(0033) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0034) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(0035) RecordValidation(ABC) 1 Validate a record against the dictionary
(0036) SaveButton(ABC) 1 Update Customers record on disk
(9) Local Templates • (TIER-4)

 5 – Template Type: Splash
  – – Procedure Name: JumpStartSplash06()
Count Local Template Name Qty Local Template Description
(0037) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp • (TIER-2) •
(0038) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp • (TIER-2) •
(0039) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp • (TIER-2) •
(0040) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0041) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl • (TIER-2) • (2)
(0042) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0043) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(7) Local Templates • (TIER-4)

 6 – Template Type: Frame
  – – Procedure Name: MainEntryPoint()
Count Local Template Name Qty Local Template Description
(0044) EmbedDiskFunctions(HNDTools) 1 © CHT EmbedDiskFunctions • (TIER-2) •
(0045) EmbedRegistryFunctions(HNDTools) 1 © CHT EmbedRegistryFunctions • (TIER-2) •
(0046) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0047) HandyHelpFileFetch(HNDTools) 6 © CHT HandyHelpFileFetch • (TIER-1) • (12)
(0048) HandyHelpWhatsNew(HNDTools) 1 © CHT HandyHelpWhatsNew • (TIER-1) • (8)
(0049) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0050) ProcedureTransparentControls(HNDTools) 1 © CHT ProcedureTransparentControls • (TIER-1) •
(7) Local Templates • (TIER-4)

Copyright © 1996-2023 - CHT Version: [27B.00.00]
Gus M. Creces, CLARION HANDY TOOLS
All Rights Reserved Worldwide

chtlogo001.gif
Application Templates