This application demonstrates CHT Explorerbrowse used in an SQL setting. It illustrates these concepts: • BRWSQLA_ExplorerBrowse_Grey • - ExplorerBrowse Locator ControlEx in drill-down mode. • BRWSQLB_ExplorerBrowse_Red • - ExplorerBrowse Locator ControlEx in drill-down mode. • BRWSQLC_ExplorerBrowse_Green • - ExplorerBrowse Locator ControlEx in drill-down mode. • BRWSQLD_ExplorerBrowse_Blue • - ExplorerBrowse Locator ControlEx in drill-down mode. • Hiding/unhiding columns programmatically. • Hidden columns are hidden also in Query Builder. • SQL Tracing set to ON in all browses, trace with <13,10>- HNDSQLTRACE.EXE. 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) | ApplicationImagesEx(HNDTools) | 1 | © CHT ApplicationImagesEx • (TIER-1) • | |
(0003) | GlobalIncludeHNDDiskFunctions(HNDTools) | 1 | © CHT GlobalIncludeHNDDiskFunctions • (TIER-2) • | |
(0004) | HNDCMPControlPanel(HNDTools) | 1 | © CHT HNDCMPControlPanel • (TIER-2) • | |
(0005) | HandyVersionResource(HNDTools) | 1 | © CHT HandyVersionResource • (TIER-1) • | |
(0006) | INIFile(HNDTools) | 1 | © CHT INIFile • (TIER-1) • | |
(0007) | VblFileNames(HNDTools) | 1 | © CHT VblFileNames • (TIER-1) • | |
(7) Global Templates • (TIER-2) | ||||
1 – Template Type: Window | ||||
– – Procedure Name: BRWSQLA_ExplorerBrowse_Grey() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0008) | BrowseBox(ABC) | 1 | Browse on Customers () | |
(0009) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
(0010) | CodeTabMenuHooks(HNDTools) | 1 | © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (6) | |
(0011) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0012) | ExplorerBrowse(HNDTools) | 1 | © CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) • | |
(0013) | ExplorerBrowseQueryBuilderControl(HNDTools) | 1 | © CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (3) | |
(0014) | HandyQueryTracingButton_EXPB(HNDTools) | 1 | © button that enables flexible query tracing on CHT ExplorerBrowse | |
(0015) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
(0016) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0017) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
(10) Local Templates • (TIER-2) | ||||
2 – Template Type: Window | ||||
– – Procedure Name: BRWSQLC_ExplorerBrowse_Green() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0018) | BrowseBox(ABC) | 1 | Browse on Customers () | |
(0019) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
(0020) | CodeTabMenuHooks(HNDTools) | 1 | © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (6) | |
(0021) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0022) | ExplorerBrowse(HNDTools) | 1 | © CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) • | |
(0023) | ExplorerBrowseQueryBuilderControl(HNDTools) | 1 | © CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (3) | |
(0024) | HandyQueryTracingButton_EXPB(HNDTools) | 1 | © button that enables flexible query tracing on CHT ExplorerBrowse | |
(0025) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
(0026) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0027) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
(10) Local Templates • (TIER-2) | ||||
3 – Template Type: Window | ||||
– – Procedure Name: CompanyUpdateForm() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0028) | CancelButton(ABC) | 1 | Cancel the Current Operation | |
(0029) | CodeTabMenuHooks(HNDTools) | 1 | © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (6) | |
(0030) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0031) | FormVCRControls(ABC) | 1 | Allow Form to be driven by Toolbar VCR Controls | |
(0032) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0033) | RecordValidation(ABC) | 1 | Validate a record against the dictionary | |
(0034) | SaveButton(ABC) | 1 | Update Customers record on disk | |
(7) Local Templates • (TIER-2) | ||||
4 – Template Type: IniTableIOProcedure | ||||
– – Procedure Name: HNDIniIOProcedure() | ||||
Count | Local Template Name | Qty | Local Template Description | |
() Local Templates • (TIER-2) | ||||
5 – Template Type: Window | ||||
– – Procedure Name: BRWSQLD_ExplorerBrowse_Blue() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0035) | BrowseBox(ABC) | 1 | Browse on Customers () | |
(0036) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
(0037) | CodeTabMenuHooks(HNDTools) | 1 | © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (8) | |
(0038) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0039) | ExplorerBrowse(HNDTools) | 1 | © CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) • | |
(0040) | ExplorerBrowseQueryBuilderControl(HNDTools) | 1 | © CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (3) | |
(0041) | HandyQueryTracingButton_EXPB(HNDTools) | 1 | © button that enables flexible query tracing on CHT ExplorerBrowse | |
(0042) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
(0043) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0044) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
(10) Local Templates • (TIER-2) | ||||
6 – Template Type: Window | ||||
– – Procedure Name: BRWSQLB_ExplorerBrowse_Red() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0045) | BrowseBox(ABC) | 1 | Browse on Customers () | |
(0046) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
(0047) | CodeTabMenuHooks(HNDTools) | 1 | © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (4) | |
(0048) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0049) | ExplorerBrowse(HNDTools) | 1 | © CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) • | |
(0050) | ExplorerBrowseQueryBuilderControl(HNDTools) | 1 | © CHT ExplorerBrowseQueryBuilderControl • (TIER-1) • (CODE-TABS) • (3) | |
(0051) | HandyQueryTracingButton_EXPB(HNDTools) | 1 | © button that enables flexible query tracing on CHT ExplorerBrowse | |
(0052) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
(0053) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0054) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
(10) Local Templates • (TIER-2) | ||||
7 – Template Type: Frame | ||||
– – Procedure Name: MainEntryPoint() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0055) | CodeTabMenuHooks(HNDTools) | 1 | © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (2) | |
(0056) | EmbedRegistryFunctions(HNDTools) | 1 | © CHT EmbedRegistryFunctions • (TIER-2) • | |
(0057) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0058) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(4) Local Templates • (TIER-2) | ||||
8 – Template Type: Splash | ||||
– – Procedure Name: JumpStartSplash06() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0059) | AppBuildDateTimeStamp(HNDTools) | 1 | © CHT AppBuildDateTimeStamp • (TIER-2) • | |
(0060) | AppBuildNumberStamp(HNDTools) | 1 | © CHT AppBuildNumberStamp • (TIER-2) • | |
(0061) | AppCopyRightStamp(HNDTools) | 1 | © CHT AppCopyRightStamp • (TIER-2) • | |
(0062) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0063) | HandyTellMeControl(HNDTools) | 1 | © CHT HandyTellMeControl • (TIER-2) • (2) | |
(0064) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(6) Local Templates • (TIER-2) | ||||