GENERATED: MAR 31,2012 - 3:09PM
SQLFillViewFromQueue Demo [V8.01.00]

Previous Page
This application demonstrates filling an ABC browse queue using a new CHT Browse extension method called SQLFillQueueFromView().

It illustrates these concepts:
• • •  SQLFillQueueFromView() example of filling browse queue.
• • •  HINI.BINIO.DumpQueue('queuename.txt') example.

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.

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: Report
SQLQueryDirectToOrdersReport (*STRING xQuery, STRING xOrder)
Count Local Template Name Qty Local Template Description
(0007) HandyQueryReportLimiter(HNDTools) 1 HandyQueryReportLimiter - Limit reported records via passed-in query or filter.
(0008) HandyTellMeControl(HNDTools) 1 HandyTellMeControl - Text box control to provide a message or help text.
(0009) PauseButton(ABC) 1 Pause the Process
(0010) ProcedureImagesEx(HNDTools) 2 ProcedureImagesEx - A tool to better control the use of images and icons in your procedure.
(0011) SetSQLAliasesToFilePrefix(HNDTools) 1 SetSQLAliasesToFilePrefix - Sets Aliases Of View Files To DCT File Prefixes
(5) Local Templates Found In SQLQueryDirectToOrdersReport

2 - Procedure Template Type: Window
ExplorerBrowseWithExtendedLocator ()
Count Local Template Name Qty Local Template Description
(0012) BrowseBox(ABC) 1 Browse on Customers
(0013) BrowseUpdateButtons(ABC) 1 Update a Record from Browse Box on Customers
(0014) EmbedWindowFunctions(HNDTools) 1 EmbedWindowFunctions - An Instance Of:
(0015) ExplorerBrowse(HNDTools) 1 ExplorerBrowse - Explorer-like ABC browse with multi-column sorts on table: Customers
(0016) ExplorerBrowseLocatorControlEx(HNDTools) 1 ExplorerBrowseLocatorControlEx - Attach an EXTENDED CHT locator control to your Clarion Handy Tools ExplorerBrowse procedure.(3)
(0017) HandyQueryReportButton(HNDTools) 1 HandyQueryReportButton - Start a HandyQueryReportLimiter-extended report procedure.(6)
(0018) HandyThreadLimiter(HNDTools) 1 HandyThreadLimiter - Limit threaded procedures to one instance.
(0019) ProcedureImagesEx(HNDTools) 1 ProcedureImagesEx - A tool to better control the use of images and icons in your procedure.
(8) Local Templates Found In ExplorerBrowseWithExtendedLocator

3 - Procedure Template Type: Splash
JumpStartSplashCHTBlue ()
Count Local Template Name Qty Local Template Description
(0020) AppBuildDateTimeStamp(HNDTools) 1 AppBuildDateTimeStamp - An application build date/time stamp.
(0021) AppBuildNumberStamp(HNDTools) 1 AppBuildNumberStamp - An application build number or version stamp.
(0022) AppCopyRightStamp(HNDTools) 1 AppCopyRightStamp - An application copyright stamp.
(0023) HandyTellMeControl(HNDTools) 1 HandyTellMeControl - Text box control to provide a message or help text.
(0024) 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
CompanyUpdateForm ()
Count Local Template Name Qty Local Template Description
(0025) CancelButton(ABC) 1 Cancel the Current Operation
(0026) EmbedWindowFunctions(HNDTools) 1 EmbedWindowFunctions - An Instance Of:
(0027) FormVCRControls(ABC) 1 Allow Form to be driven by Toolbar VCR Controls
(0028) ProcedureImagesEx(HNDTools) 1 ProcedureImagesEx - A tool to better control the use of images and icons in your procedure.
(0029) RecordValidation(ABC) 1 Validate a record against the dictionary
(0030) SaveButton(ABC) 1 Update Customers record on disk
(6) Local Templates Found In CompanyUpdateForm

5 - Procedure Template Type: IniTableIOProcedure
IniTableIOProcedure (BYTE xIoType, STRING xSector, STRING xName, <STRING xValue>, <STRING xFilename>),STRING,PROC
Count Local Template Name Qty Local Template Description
(0031) ProcedureImagesEx(HNDTools) 1 ProcedureImagesEx - A tool to better control the use of images and icons in your procedure.
(1) Local Templates Found In IniTableIOProcedure

6 - Procedure Template Type: Frame
MainEntryPoint ()
Count Local Template Name Qty Local Template Description
(0032) EmbedDiskFunctions(HNDTools) 1 EmbedDiskFunctions - An Instance Of:
(0033) EmbedRegistryFunctions(HNDTools) 1 EmbedRegistryFunctions - An Instance Of:
(0034) EmbedWindowFunctions(HNDTools) 1 EmbedWindowFunctions - An Instance Of:
(0035) HandyHelpFileFetch(HNDTools) 2 HandyHelpFileFetch - Build A Help File Request To Your Website.(7)
(0036) HandyHelpWhatsNew(HNDTools) 1 HandyHelpWhatsNew - Build A What's New Request To Your Website.(8)
(0037) ProcedureImagesEx(HNDTools) 1 ProcedureImagesEx - A tool to better control the use of images and icons in your procedure.
(6) Local Templates Found In MainEntryPoint

7 - Procedure Template Type: Source
RegisterODBC ()
Count Local Template Name Qty Local Template Description
(0038) EmbedObject(HNDTools) 2 EmbedObject - An Instance Of:
(0039) ProcedureImagesEx(HNDTools) 1 ProcedureImagesEx - A tool to better control the use of images and icons in your procedure.
(2) Local Templates Found In RegisterODBC

Copyright © 1996-2012
Gus M. Creces and The Clarion Handy Tools Page.
All Rights Reserved Worldwide

chtlogo001.gif Templates In Application: HNDSQL10.APP