GENERATED: JUL 19,2019 - 1:26PM
SQL Trace Utility [V10.19.07]

Previous Page
This "CHT Utility Application" is designed to help you with your SQL application development projects by assisting with easy SQL tracing.

Start tracing by configuring the specific driver(s) used by your SQL application followed by a click on the "Minimize" button . Once this application is started, then start your SQL application.

Navigate in your SQL application to the specific area to be tested and bring HNDSQLTRACE.APP back up using the windows task bar icon menu provided.

Manual tracing:
When HNDSQLTRACE.APP re-appears all SQL statements executed to that point are displayed in reverse chronological order, with newest statements at the top. From this point forward, to trace specific actions, click the "Clear" button and interact briefly with your SQL application. Click the "Read Next" button to view the most recent SQL activity raised by your application. Repeat as necessary.

Automatic tracing:
Check the "Auto Trace" switch. A window timer will periodically refresh to the latest SQL select or group of selects issued by your application.

File Trace or Direct Trace:
These modes are mutually exclusive.

File trace is performed by communicating with SQL trace information issued by Clarion's file drivers into a text file. In "File Trace" mode a developer can trace any and all SQL select outputs from various browses in an application as long as HNDSQLTRACE.EXE is started and configured before starting the application.

"Direct Trace" mode is performed by low-level communication, usually from a specific procedure under scrutiny. This mode requires one of CHT's browse templates to be configured to issue trace information during interaction with the user.

This application includes the template CHTBestPracticeEmbedClass as an example for developers to study.

NOTE: As of November 1, 2015, and C10 Version 11975 file trace configuration information is now stored in "DRIVERS.INI" located at CSIDL_APPDATA\SoftVelocity\Clarion\CLARION_VERSION\.
In all earlier versions of clarion, file trace configuration information was located in long obsolete, win.ini.

Count Global Template Name Qty Global Template Description
(0001) AACHTControlPanel(HNDTools) 1 CHT AACHTControlPanel - CHT Global Control Panel.
(0002) ApplicationImagesEx(HNDTools) 1 CHT ApplicationImagesEx - Application Styling System
(0003) ApplicationSnapIns(HNDTools) 1 CHT ApplicationSnapIns - Application Snap-In System
(0004) GlobalIncludeHNDDiskFunctions(HNDTools) 1 CHT GlobalIncludeHNDDiskFunctions - Disk classes - HNDDisk - globally to your application.
(0005) HNDCMPControlPanel(HNDTools) 1 CHT HNDCMPControlPanel - Interface to the CHT Compile Manager.
(0006) HandyCodeSigningExtension(HNDTools) 1 CHT HandyCodeSigningExtension - Application Code-Signing System
(0007) HandyVersionResource(HNDTools) 1 CHT HandyVersionResource - Version Resource/Build Number Information To EXE
(0008) INIFile(HNDTools) 1 CHT INIFile - .INI FIle and Registry extension classes - HNDIni - globally to your application.
(0009) VblFileNames(HNDTools) 1 CHT VblFileNames - Incorporate variable file names and defaults into your app from the dictionary.
(9) Global Templates Found

1 - Procedure Template Type: Splash
JumpStartSplashCHTBlue ()
Count Local Template Name Qty Local Template Description
(0010) AppBuildDateTimeStamp(HNDTools) 1 CHT AppBuildDateTimeStamp - An application build date/time stamp.
(0011) AppBuildNumberStamp(HNDTools) 1 CHT AppBuildNumberStamp - An application build number or version stamp.
(0012) AppCopyRightStamp(HNDTools) 1 CHT AppCopyRightStamp - An application copyright stamp.
(0013) HandyTellMeControl(HNDTools) 1 CHT HandyTellMeControl - Text box control to provide a message or help text.
(0014) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0015) ProcedureSnapIns(HNDTools) 1 CHT ProcedureSnapIns - Application Snap-In System
(6) Local Templates Found In JumpStartSplashCHTBlue

2 - Procedure Template Type: Window
Main ()
Count Local Template Name Qty Local Template Description
(0016) AppStartSplashProcedure(HNDTools) 1 CHT AppStartSplashProcedure - Application Splash screen earlier with an option for threaded/unthreaded.
(0017) CHTBestPracticeEmbedClass(HNDTools) 1 CHT CHTBestPracticeEmbedClass CHT Best Practice Embedding Assistant
(0018) CloseCurrentWindow(ABC) 1 Close Current Window and Procedure(24)
(0019) EmbedShellLinkClassFunctions(HNDTools) 1 CHT EmbedShellLinkClassFunctions - An Instance Of:
(0020) EmbedWindowFunctions(HNDTools) 1 CHT EmbedWindowFunctions - An Instance Of:
(0021) ExtendedEvents_EWF(HNDTools) 1 CHT ExtendedEvents_EWF - Intercept extended events on a Callback window. Requires EmbedWindowFunctions Template.(21)
(0022) HandyApplicationIniPut(HNDTools) 11 CHT HandyApplicationIniPut - Embed a PUT to the Application INI file or Windows registry.(22)
(0023) HandyHelpFileFetch(HNDTools) 7 CHT HandyHelpFileFetch - Build A Help File Request To Your Website.(30)
(0024) HandyHelpWhatsNew(HNDTools) 1 CHT HandyHelpWhatsNew - Build A What's New Request To Your Website.(15)
(0025) HandyToolBarGradient(HNDTools) 1 CHT HandyToolBarGradient - Place gradient properties as a backdrop on the window toolbar.
(0026) ProcedureImagesEx(HNDTools) 1 CHT ProcedureImagesEx - Application Styling System
(0027) ProcedureSnapIns(HNDTools) 1 CHT ProcedureSnapIns - Application Snap-In System
(0028) ResizeHandles(HNDTools) 1 CHT ResizeHandles - Attach "grip-style" resize handles to any window.
(13) Local Templates Found In Main

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

chtlogo001.gif Templates In Application: HNDSQLTRACE.APP