GENERATED: JUL 10,2017 - 11:19PM
SQL Drill-Down Locator Examples [V10.17.05.0250]

Previous Page
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 CHT AACHTControlPanel - Global Control Panel.
(0002) ApplicationImagesEx(HNDTools) 1 CHT ApplicationImagesEx - Application Styling System
(0003) HNDCMPControlPanel(HNDTools) 1 CHT HNDCMPControlPanel - Interface to the CHT Compile Manager.
(0004) HandyVersionResource(HNDTools) 1 CHT HandyVersionResource - Version Resource/Build Number Information To EXE
(0005) INIFile(HNDTools) 1 CHT INIFile - .INI FIle and Registry extension classes - HNDIni - globally to your application.
(0006) VblFileNames(HNDTools) 1 CHT 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 CHT EmbedObject - An Instance Of:
(0008) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(2) Local Templates Found In JumpStartHTTPRunHelpMediaWithAnimation

2 - Procedure Template Type: Frame
Main ()
Count Local Template Name Qty Local Template Description
(0009) EmbedDiskFunctions(HNDTools) 1 CHT EmbedDiskFunctions - Disk Functions Classes - An Instance Of:
(0010) EmbedRegistryFunctions(HNDTools) 1 CHT EmbedRegistryFunctions - An Instance Of:
(0011) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0012) HandyHelpFileFetch(HNDTools) 2 CHT HandyHelpFileFetch - Build A Help File Request To Your Website.(8)
(0013) HandyHelpWhatsNew(HNDTools) 1 CHT HandyHelpWhatsNew - Build A What's New Request To Your Website.(5)
(0014) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(6) Local Templates Found In Main

3 - Procedure Template Type: Splash
JumpStartSplashCHTBlue ()
Count Local Template Name Qty Local Template Description
(0015) AppBuildDateTimeStamp(HNDTools) 1 CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0016) AppBuildNumberStamp(HNDTools) 1 CHT AppBuildNumberStamp - An application build number or version stamp.
(0017) AppCopyRightStamp(HNDTools) 1 CHT AppCopyRightStamp - An application copyright stamp.
(0018) HandyTellMeControl(HNDTools) 1 CHT HandyTellMeControl - Text box control to provide a message or help text.
(0019) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(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 CHT EmbedWindowFunctions - An Instance Of:
(0024) HandyQueryProcessButton(HNDTools) 1 CHT HandyQueryProcessButton for procedure: SQLQueryToHTMLCustomerProcess
(0025) HandyQueryReportButton(HNDTools) 1 CHT HandyQueryReportButton - Start a HandyQueryReportLimiter-extended report procedure.(2)
(0026) HandyThreadLimiter(HNDTools) 1 CHT HandyThreadLimiter - Limit threaded procedures to one instance.
(0027) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0028) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0029) LocatorOverRideControl(HNDTools) 1 CHT LocatorOverRideControl - Explorer-like browse with locator and query control all-in-one.(5)
(0030) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(11) Local Templates Found In SQLDrillDown_LocatorOverRideControl

5 - Procedure Template Type: Window
SQLDrillDown_HandyMarkerBrowse ()
Count Local Template Name Qty Local Template Description
(0031) BrowseBox(ABC) 1 Browse on Customers ()
(0032) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0033) CloseButton(ABC) 1 Close the Window
(0034) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0035) HandyMarkerBrowse(HNDTools) 1 CHT HandyMarkerBrowse - Explorer-like ABC browse with record marking on table: Customers
(0036) HandyMarkerBrowseLocatorControlEx(HNDTools) 1 CHT HandyMarkerBrowseLocatorControlEX - Attach an EXTENDED Locator Control to your Clarion Handy Tools HandyMarkerBrowse.(7)
(0037) HandyMarkerBrowseProcessButton(HNDTools) 1 CHT HandyMarkerBrowseProcessButton - Start a HandyMarkerBrowseProcessLimiter procedure.(13)
(0038) HandyMarkerBrowseReportButton(HNDTools) 1 CHT HandyMarkerBrowseReportButton - Start a HandyMarkerBrowseReportLimiter procedure.(8)
(0039) HandyThreadLimiter(HNDTools) 1 CHT HandyThreadLimiter - Limit threaded procedures to one instance.
(0040) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0041) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0042) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(12) Local Templates Found In SQLDrillDown_HandyMarkerBrowse

6 - Procedure Template Type: Process
SQLQueryToHTMLCustomerProcess (*STRING xQuery)
Count Local Template Name Qty Local Template Description
(0043) HandyQueryProcessLimiter(HNDTools) 1 CHT HandyQueryProcessLimiter - Limit processed records via passed-in query or filter.
(0044) HandyTellMeControl(HNDTools) 1 CHT HandyTellMeControl - Text box control to provide a message or help text.
(0045) PauseButton(ABC) 1 Pause the Process
(0046) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(4) Local Templates Found In SQLQueryToHTMLCustomerProcess

7 - Procedure Template Type: Window
SQLDrillDown_ExplorerBrowse ()
Count Local Template Name Qty Local Template Description
(0047) BrowseBox(ABC) 1 Browse on Customers ()
(0048) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0049) CloseButton(ABC) 1 Close the Window
(0050) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0051) ExplorerBrowse(HNDTools) 1 CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Customers
(0052) ExplorerBrowseLocatorControl(HNDTools) 1 CHT ExplorerBrowseLocatorControl - Attach a CHT locator control to your Clarion Handy Tools ExplorerBrowse procedure.(7)
(0053) HandyQueryProcessButton(HNDTools) 1 CHT HandyQueryProcessButton for procedure: SQLQueryToHTMLCustomerProcess
(0054) HandyQueryReportButton(HNDTools) 1 CHT HandyQueryReportButton - Start a HandyQueryReportLimiter-extended report procedure.(8)
(0055) HandyThreadLimiter(HNDTools) 1 CHT HandyThreadLimiter - Limit threaded procedures to one instance.
(0056) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0057) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0058) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(12) Local Templates Found In SQLDrillDown_ExplorerBrowse

8 - Procedure Template Type: Report
SQLQueryDirectToOrdersReport (*STRING xQuery)
Count Local Template Name Qty Local Template Description
(0059) HandyQueryReportLimiter(HNDTools) 1 CHT HandyQueryReportLimiter - Limit reported records via passed-in query or filter.
(0060) HandyTellMeControl(HNDTools) 1 CHT HandyTellMeControl - Text box control to provide a message or help text.
(0061) PauseButton(ABC) 1 Pause the Process
(0062) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(4) Local Templates Found In SQLQueryDirectToOrdersReport

9 - Procedure Template Type: Window
UpdateFormWithSQLBrowse ()
Count Local Template Name Qty Local Template Description
(0063) BrowseBox(ABC) 2 Browse on Order_Details ()
(0064) CancelButton(ABC) 1 Cancel the Current Operation
(0065) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0066) ExplorerBrowse(HNDTools) 2 CHT ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Order_Details
(0067) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0068) HandyWindowGradient(HNDTools) 1 CHT HandyWindowGradient - Place gradient properties as a backdrop on the window.
(0069) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0070) RecordValidation(ABC) 1 Validate a record against the dictionary
(0071) SaveButton(ABC) 1 Update Customers record on disk
(9) Local Templates Found In UpdateFormWithSQLBrowse

Copyright © 1996-2017 - CHT Version: [21C.00.00]
Gus M. Creces and The Clarion Handy Tools Page.
All Rights Reserved Worldwide

chtlogo001.gif Templates In Application: HNDDRLDN.APP