Templates In Application: HNDDRLDN.APP
|
In this application, we're illustrating some new SQL "drill-down" capabilities build into the locators available for ExplorerBrowse, LocatorOverRideControl and HandyMarkerBrowse. When any of these locators is configured to act as a filtering locator you have the option of asking the template to remember the last locator query and to re-apply it with your next locator query. The more locates performed before the locator clear button is clicked, the deeper you drill down into the current data set. A new feature on the HandyMarkerBrowseProcessButton and HandyMarkerBrowesReportButton templates lets you opt to have the marked record set translated into an SQL IN(x,y,z) request to be sent to a report or process rather than a queue of marked records. Default behavior is as before, to send a queue. This demonstration application requires the sample data base provided with MICROSOFT ACCESS, called Northwind. You do not need a copy of the Microsoft Access to test this, and a copy of NORTHWIND.MDB is included in the install. The application will find the data base and register it with ODBC if not already registered. Cheers, Gus M. Creces The Clarion Handy Tools Page www.cwhandy.ca (CHT Website) news.cwhandy.ca (CHT Forum) |
| Count | Global Template Name | Qty | Global Template Description | |
| (0001) | AACHTControlPanel(HNDTools) | 1 | AACHTControlPanel - CHT Global Control Panel. | |
| (0002) | ApplicationImagesEx(HNDTools) | 1 | ApplicationImagesEx - A tool to better control the use of images and icons in your application. | |
| (0003) | HNDCMPControlPanel(HNDTools) | 1 | HNDCMPControlPanel - Interface to the CHT Compile Manager. | |
| (0004) | HandyVersionResource(HNDTools) | 1 | HandyVersionResource - Version Resource/Build Number Information To EXE | |
| (0005) | INIFile(HNDTools) | 1 | INIFile - Attach CHT .INI FIle and Registry extension classes - HNDIni - globally to your application. | |
| (0006) | VblFileNames(HNDTools) | 1 | VblFileNames - Incorporate variable file names and defaults into your app from the dictionary. | |
| (6) Global Templates Found | ||||
| 1 - Procedure Template Type: Source | ||||
| JumpStartHTTPRunHelpMediaWithAnimation (STRING xWinTitle, STRING xExeName) | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0007) | EmbedObject(HNDTools) | 3 | EmbedObject - An Instance Of: | |
| (0008) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (2) Local Templates Found In JumpStartHTTPRunHelpMediaWithAnimation | ||||
| 2 - Procedure Template Type: Frame | ||||
| Main () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0009) | EmbedDiskFunctions(HNDTools) | 1 | EmbedDiskFunctions - An Instance Of: | |
| (0010) | EmbedRegistryFunctions(HNDTools) | 1 | EmbedRegistryFunctions - An Instance Of: | |
| (0011) | EmbedWindowFunctions(HNDTools) | 1 | EmbedWindowFunctions - An Instance Of: | |
| (0012) | HandyHelpFileFetch(HNDTools) | 2 | HandyHelpFileFetch - Build A Help File Request To Your Website.(8) | |
| (0013) | HandyHelpWhatsNew(HNDTools) | 1 | HandyHelpWhatsNew - Build A What's New Request To Your Website.(5) | |
| (0014) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (6) Local Templates Found In Main | ||||
| 3 - Procedure Template Type: Splash | ||||
| JumpStartSplashCHTBlue () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0015) | AppBuildDateTimeStamp(HNDTools) | 1 | AppBuildDateTimeStamp - An application build date/time stamp. | |
| (0016) | AppBuildNumberStamp(HNDTools) | 1 | AppBuildNumberStamp - An application build number or version stamp. | |
| (0017) | AppCopyRightStamp(HNDTools) | 1 | AppCopyRightStamp - An application copyright stamp. | |
| (0018) | HandyTellMeControl(HNDTools) | 1 | HandyTellMeControl - Text box control to provide a message or help text. | |
| (0019) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (5) Local Templates Found In JumpStartSplashCHTBlue | ||||
| 4 - Procedure Template Type: Window | ||||
| SQLDrillDown_LocatorOverRideControl () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0020) | BrowseBox(ABC) | 1 | Browse on Customers | |
| (0021) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
| (0022) | CloseButton(ABC) | 1 | Close the Window | |
| (0023) | EmbedWindowFunctions(HNDTools) | 1 | EmbedWindowFunctions - An Instance Of: | |
| (0024) | HandyQueryProcessButton(HNDTools) | 1 | HandyQueryProcessButton for procedure: SQLQueryToHTMLCustomerProcess | |
| (0025) | HandyQueryReportButton(HNDTools) | 1 | HandyQueryReportButton - Start a HandyQueryReportLimiter-extended report procedure.(2) | |
| (0026) | HandyThreadLimiter(HNDTools) | 1 | HandyThreadLimiter - Limit threaded procedures to one instance. | |
| (0027) | LocatorOverRideControl(HNDTools) | 1 | LocatorOverRideControl - Explorer-like browse with locator and query control all-in-one.(5) | |
| (0028) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (9) Local Templates Found In SQLDrillDown_LocatorOverRideControl | ||||
| 5 - Procedure Template Type: Window | ||||
| SQLDrillDown_HandyMarkerBrowse () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0029) | BrowseBox(ABC) | 1 | Browse on Customers | |
| (0030) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
| (0031) | CloseButton(ABC) | 1 | Close the Window | |
| (0032) | EmbedWindowFunctions(HNDTools) | 1 | EmbedWindowFunctions - An Instance Of: | |
| (0033) | HandyMarkerBrowse(HNDTools) | 1 | HandyMarkerBrowse - Explorer-like ABC browse with record marking on table: Customers | |
| (0034) | HandyMarkerBrowseLocatorControlEx(HNDTools) | 1 | HandyMarkerBrowseLocatorControlEX - Attach an EXTENDED CHT Locator Control to your Clarion Handy Tools HandyMarkerBrowse.(7) | |
| (0035) | HandyMarkerBrowseProcessButton(HNDTools) | 1 | HandyMarkerBrowseProcessButton - Start a HandyMarkerBrowseProcessLimiter procedure.(13) | |
| (0036) | HandyMarkerBrowseReportButton(HNDTools) | 1 | HandyMarkerBrowseReportButton - Start a HandyMarkerBrowseReportLimiter procedure.(8) | |
| (0037) | HandyThreadLimiter(HNDTools) | 1 | HandyThreadLimiter - Limit threaded procedures to one instance. | |
| (0038) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (10) Local Templates Found In SQLDrillDown_HandyMarkerBrowse | ||||
| 6 - Procedure Template Type: Process | ||||
| SQLQueryToHTMLCustomerProcess (*STRING xQuery) | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0039) | HandyQueryProcessLimiter(HNDTools) | 1 | HandyQueryProcessLimiter - Limit processed records via passed-in query or filter. | |
| (0040) | HandyTellMeControl(HNDTools) | 1 | HandyTellMeControl - Text box control to provide a message or help text. | |
| (0041) | PauseButton(ABC) | 1 | Pause the Process | |
| (0042) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (4) Local Templates Found In SQLQueryToHTMLCustomerProcess | ||||
| 7 - Procedure Template Type: Window | ||||
| SQLDrillDown_ExplorerBrowse () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0043) | BrowseBox(ABC) | 1 | Browse on Customers | |
| (0044) | BrowseUpdateButtons(ABC) | 1 | Update a Record from Browse Box on Customers | |
| (0045) | CloseButton(ABC) | 1 | Close the Window | |
| (0046) | EmbedWindowFunctions(HNDTools) | 1 | EmbedWindowFunctions - An Instance Of: | |
| (0047) | ExplorerBrowse(HNDTools) | 1 | ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Customers | |
| (0048) | ExplorerBrowseLocatorControl(HNDTools) | 1 | ExplorerBrowseLocatorControl - Attach a CHT locator control to your Clarion Handy Tools ExplorerBrowse procedure.(7) | |
| (0049) | HandyQueryProcessButton(HNDTools) | 1 | HandyQueryProcessButton for procedure: SQLQueryToHTMLCustomerProcess | |
| (0050) | HandyQueryReportButton(HNDTools) | 1 | HandyQueryReportButton - Start a HandyQueryReportLimiter-extended report procedure.(8) | |
| (0051) | HandyThreadLimiter(HNDTools) | 1 | HandyThreadLimiter - Limit threaded procedures to one instance. | |
| (0052) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (10) Local Templates Found In SQLDrillDown_ExplorerBrowse | ||||
| 8 - Procedure Template Type: Report | ||||
| SQLQueryDirectToOrdersReport (*STRING xQuery) | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0053) | HandyQueryReportLimiter(HNDTools) | 1 | HandyQueryReportLimiter - Limit reported records via passed-in query or filter. | |
| (0054) | HandyTellMeControl(HNDTools) | 1 | HandyTellMeControl - Text box control to provide a message or help text. | |
| (0055) | PauseButton(ABC) | 1 | Pause the Process | |
| (0056) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (4) Local Templates Found In SQLQueryDirectToOrdersReport | ||||
| 9 - Procedure Template Type: Window | ||||
| UpdateFormWithSQLBrowse () | ||||
| Count | Local Template Name | Qty | Local Template Description | |
| (0057) | BrowseBox(ABC) | 2 | Browse on Order_Details | |
| (0058) | CancelButton(ABC) | 1 | Cancel the Current Operation | |
| (0059) | EmbedWindowFunctions(HNDTools) | 1 | EmbedWindowFunctions - An Instance Of: | |
| (0060) | ExplorerBrowse(HNDTools) | 2 | ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Order_Details | |
| (0061) | FormVCRControls(ABC) | 1 | Allow Form to be driven by Toolbar VCR Controls | |
| (0062) | ProcedureImagesEx(HNDTools) | 1 | ProcedureImagesEx - A tool to better control the use of images and icons in your procedure. | |
| (0063) | RecordValidation(ABC) | 1 | Validate a record against the dictionary | |
| (0064) | SaveButton(ABC) | 1 | Update Customers record on disk | |
| (8) Local Templates Found In UpdateFormWithSQLBrowse | ||||
Templates In Application: HNDDRLDN.APP