This application demonstrates CHT Explorerbrowse used in an SQL setting in conjunction with query template PopFavoriteQueries_EXPB (PFQ_EXPB) It illustrates these concepts: • • • An Explorerbrowse implementation running on SQL Data Tables. • • • CHT Query template PopFavoriteQueries_EXPB • • • Default query applied on browse opening is under user, run-time control • • • Concatentaion of two fields (TELEPHONE + FAX) in a single column • • • TELEPHONE and FAX are individually queryable from PFQ_EXPB • • • SetExplorerBrowseQueryBindings - enables querying of fields not individually displayed in the browse. for example: FAX This demonstration application requires the sample data tables provided with MICROSOFT ACCESS, called Northwind. The CHT toolkit installs these Northwind tables for you. The application finds these tables and registers them with ODBC if not already registered when you first run this demo app. |
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) | HNDCMPControlPanel(HNDTools) | 1 | © CHT HNDCMPControlPanel • (TIER-2) • | |
(0004) | HandyVersionResource(HNDTools) | 1 | © CHT HandyVersionResource • (TIER-1) • | |
(0005) | INIFile(HNDTools) | 1 | © CHT INIFile • (TIER-1) • | |
(0006) | VblFileNames(HNDTools) | 1 | © CHT VblFileNames • (TIER-1) • | |
(6) Global Templates • (TIER-2) | ||||
1 – Template Type: Browse | ||||
– – Procedure Name: JumpStartManagePreBuiltQueriesSQL() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0007) | BrowseBox(ABC) | 1 | Browse on PreQueries () | |
(0008) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on PreQueries | |
(0009) | CloseButton(ABC) | 1 | Close the Window | |
(0010) | CodeTabEventHooks(HNDTools) | 1 | © CHT CodeTabEventHooks • (TIER-1 • (CODE-TABS) • (5) | |
(0011) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0012) | ExplorerBrowse(HNDTools) | 1 | © CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) • | |
(0013) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
(0014) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
(0015) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0016) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
(10) Local Templates • (TIER-2) | ||||
2 – Template Type: Splash | ||||
– – Procedure Name: JumpStartSplash06() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0017) | AppBuildDateTimeStamp(HNDTools) | 1 | © CHT AppBuildDateTimeStamp • (TIER-2) • | |
(0018) | AppBuildNumberStamp(HNDTools) | 1 | © CHT AppBuildNumberStamp • (TIER-2) • | |
(0019) | AppCopyRightStamp(HNDTools) | 1 | © CHT AppCopyRightStamp • (TIER-2) • | |
(0020) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0021) | HandyTellMeControl(HNDTools) | 1 | © CHT HandyTellMeControl • (TIER-2) • (2) | |
(0022) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(6) Local Templates • (TIER-2) | ||||
3 – Template Type: Window | ||||
– – Procedure Name: CompanyUpdateForm() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0023) | CancelButton(ABC) | 1 | Cancel the Current Operation | |
(0024) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0025) | FormVCRControls(ABC) | 1 | Allow Form to be driven by Toolbar VCR Controls | |
(0026) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
(0027) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0028) | RecordValidation(ABC) | 1 | Validate a record against the dictionary | |
(0029) | SaveButton(ABC) | 1 | Update Customers record on disk | |
(7) Local Templates • (TIER-2) | ||||
4 – Template Type: Window | ||||
– – Procedure Name: ExplorerBrowseWithPopFavoriteQueries_EXPB() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0030) | BrowseBox(ABC) | 1 | Browse on Customers () | |
(0031) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
(0032) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0033) | ExplorerBrowse(HNDTools) | 1 | © CHT ExplorerBrowse • (TIER-1) • (CODE-TABS) • | |
(0034) | HandyThreadLimiter(HNDTools) | 1 | © CHT HandyThreadLimiter • (TIER-1) • | |
(0035) | HandyToolBarGradient(HNDTools) | 1 | © CHT HandyToolBarGradient • (TIER-2) • | |
(0036) | HandyWindowGradient(HNDTools) | 1 | © CHT HandyWindowGradient • (TIER-2) • | |
(0037) | PopFavoriteQueries_EXPB(HNDTools) | 1 | © CHT PopFavoriteQueries_EXPB • (TIER-1) • (CODE-TABS) • | |
(0038) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(0039) | ResizeHandles(HNDTools) | 1 | © CHT ResizeHandles • (TIER-2) • (CODE-TABS) • | |
(0040) | SetExplorerBrowseQueryBuilderBindings(HNDTools) | 1 | © CHT SetExplorerBrowseQueryBuilderBindings • (TIER-1) • (6) | |
(11) Local Templates • (TIER-2) | ||||
5 – Template Type: Frame | ||||
– – Procedure Name: MainEntryPoint() | ||||
Count | Local Template Name | Qty | Local Template Description | |
(0041) | EmbedDiskFunctions(HNDTools) | 1 | © CHT EmbedDiskFunctions • (TIER-2) • | |
(0042) | EmbedRegistryFunctions(HNDTools) | 1 | © CHT EmbedRegistryFunctions • (TIER-2) • | |
(0043) | EmbedWindowFunctions(HNDTools) | 1 | © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) • | |
(0044) | ProcedureImagesEx(HNDTools) | 1 | © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) • | |
(4) Local Templates • (TIER-2) | ||||