Application Templates
|
Cette application illustre CHT HandyMarkerBrowse utilisé dans un paramètre SQL. Il illustre ces concepts : • SQLFilter_HandyMarkerBrowse • - Illustre un contrôle de requête SQL construit à la main à l’aide d’un contrôle d’entrée standard codé pour afficher une requête SQL dans la table de données. • Masquer/Démasquer les colonnes par programme • Injection SQL à partir d’un clic de bouton • SQL traçant sur et hors tension à partir d’un événement de clic de bouton. Cette application de démonstration nécessite l’exemple de base de données fournie avec MICROSOFT ACCESS, appelée Northwind. L’application trouvera la base de données et l’enregistrera auprès d’ODBC si elle n’est pas déjà enregistrée. |
| 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) | VblFileNames(HNDTools) | 1 | © CHT VblFileNames • (TIER-1) • | |
| (7) Global Templates • (TIER-2) | ||||
| 1 – Template Type: Splash | ||||
| – – Procedure Name: JumpStartSplash07() | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0008) | AppBuildDateTimeStamp(HNDTools) | 1 | © CHT AppBuildDateTimeStamp • (TIER-2) • | |
| (0009) | AppBuildNumberStamp(HNDTools) | 1 | © CHT AppBuildNumberStamp • (TIER-2) • | |
| (0010) | AppCopyRightStamp(HNDTools) | 1 | © CHT AppCopyRightStamp • (TIER-2) • | |
| (0011) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0012) | HandyTellMeControl(HNDTools) | 1 | © CHT HandyTellMeControl • (TIER-2) • (2) | |
| (0013) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0014) | ProcedureTransparentControls(HNDTools) | 1 | © CHT ProcedureTransparentControls • (TIER-1) • | |
| (7) Local Templates • (TIER-2) | ||||
| 2 – Template Type: Window | ||||
| – – Procedure Name: SQLFilter_HandyMarkerBrowse() | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0015) | BrowseBox(ABC) | 1 | Browse on Customers () | |
| (0016) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
| (0017) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0018) | HandyMarkerBrowse(HNDTools) | 1 | © CHT HandyMarkerBrowse • (TIER-1) • (CODE-TABS) • (5) | |
| (0019) | HandyMarkerBrowseQueryBuilderControl(HNDTools) | 1 | © CHT HandyMarkerBrowseQueryBuilderControl • (TIER-1) • (8) | |
| (0020) | HandyQueryTracingButton_HMB(HNDTools) | 1 | © CHT HandyQueryTracingButton_HMB • (TIER-1) • (2) | |
| (0021) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
| (0022) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0023) | ProcedureTransparentControls(HNDTools) | 1 | © CHT ProcedureTransparentControls • (TIER-1) • | |
| (9) Local Templates • (TIER-2) | ||||
| 3 – Template Type: Source | ||||
| – – Procedure Name: RegisterODBC() | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0024) | EmbedDiskFunctions(HNDTools) | 1 | © CHT EmbedDiskFunctions • (TIER-2) • | |
| (0025) | EmbedObject(HNDTools) | 1 | © CHT EmbedObject • (TIER-4) • (3) | |
| (0026) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (3) Local Templates • (TIER-4) | ||||
| 4 – Template Type: Window | ||||
| – – Procedure Name: UpdateForm() | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0027) | CancelButton(ABC) | 1 | Cancel the Current Operation | |
| (0028) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0029) | FormVCRControls(ABC) | 1 | Allow Form to be driven by Toolbar VCR Controls | |
| (0030) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
| (0031) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
| (0032) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0033) | ProcedureTransparentControls(HNDTools) | 1 | © CHT ProcedureTransparentControls • (TIER-1) • | |
| (0034) | RecordValidation(ABC) | 1 | Validate a record against the dictionary | |
| (0035) | 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 | |
| (0036) | AppBuildDateTimeStamp(HNDTools) | 1 | © CHT AppBuildDateTimeStamp • (TIER-2) • | |
| (0037) | AppBuildNumberStamp(HNDTools) | 1 | © CHT AppBuildNumberStamp • (TIER-2) • | |
| (0038) | AppCopyRightStamp(HNDTools) | 1 | © CHT AppCopyRightStamp • (TIER-2) • | |
| (0039) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0040) | HandyTellMeControl(HNDTools) | 1 | © CHT HandyTellMeControl • (TIER-2) • (2) | |
| (0041) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0042) | 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 | |
| (0043) | EmbedDiskFunctions(HNDTools) | 1 | © CHT EmbedDiskFunctions • (TIER-2) • | |
| (0044) | EmbedRegistryFunctions(HNDTools) | 1 | © CHT EmbedRegistryFunctions • (TIER-2) • | |
| (0045) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
| (0046) | HandyHelpFileFetch(HNDTools) | 6 | © CHT HandyHelpFileFetch • (TIER-1) • (12) | |
| (0047) | HandyHelpWhatsNew(HNDTools) | 1 | © CHT HandyHelpWhatsNew • (TIER-1) • (8) | |
| (0048) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
| (0049) | ProcedureTransparentControls(HNDTools) | 1 | © CHT ProcedureTransparentControls • (TIER-1) • | |
| (7) Local Templates • (TIER-4) | ||||