GENERATED: MAY 4,2023 - 7:57AM
SQL Trace Utility [V10.23.05. 27.03]

Previous Page

This "CHT Utility Application", HNDSQLTRACE.EXE, 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.EXE back up using the windows task bar icon menu provided.

Manual tracing:
When HNDSQLTRACE.EXE 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.

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) ApplicationSnapIns(HNDTools) 1 © CHT ApplicationSnapIns • (TIER-3) •
(0004) GlobalIncludeHNDDiskFunctions(HNDTools) 1 © CHT GlobalIncludeHNDDiskFunctions • (TIER-2) •
(0005) HNDCMPControlPanel(HNDTools) 1 © CHT HNDCMPControlPanel • (TIER-2) •
(0006) HandyVersionResource(HNDTools) 1 © CHT HandyVersionResource • (TIER-1) •
(0007) INIFile(HNDTools) 1 © CHT INIFile • (TIER-1) •
(0008) VblFileNames(HNDTools) 1 © CHT VblFileNames • (TIER-1) •
(8) Global Templates • (TIER-3)

 1 – Template Type: Splash
  – – Procedure Name: JumpStartSplashCHTBlue()
Count Local Template Name Qty Local Template Description
(0009) AppBuildDateTimeStamp(HNDTools) 1 © CHT AppBuildDateTimeStamp • (TIER-2) •
(0010) AppBuildNumberStamp(HNDTools) 1 © CHT AppBuildNumberStamp • (TIER-2) •
(0011) AppCopyRightStamp(HNDTools) 1 © CHT AppCopyRightStamp • (TIER-2) •
(0012) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0013) HandyTellMeControl(HNDTools) 1 © CHT HandyTellMeControl • (TIER-2) • (2)
(0014) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0015) ProcedureSnapIns(HNDTools) 1 © CHT ProcedureSnapIns • (TIER-3) •
(7) Local Templates • (TIER-3)

 2 – Template Type: Window
  – – Procedure Name: Main()
Count Local Template Name Qty Local Template Description
(0016) AppStartSplashProcedure(HNDTools) 1 © CHT AppStartSplashProcedure • (TIER-1) • (CODE-TABS) •
(0017) CHTBestPracticeEmbedClass(HNDTools) 1 © CHT CHTBestPracticeEmbedClass • (TIER-1) • (CODE-TABS) •
(0018) CodeTabEventHooks(HNDTools) 1 © CHT CodeTabEventHooks • (TIER-1 • (CODE-TABS) • (4)
(0019) CodeTabMenuHooks(HNDTools) 3 © CHT CodeTabMenuHooks • (TIER-1) • (CODE-TABS) • (5)
(0020) EmbedShellLinkClassFunctions(HNDTools) 1 © CHT EmbedShellLinkClassFunctions • (TIER-2) • (CODE-TABS •
(0021) EmbedWindowFunctions(HNDTools) 1 © CHT EmbedWindowFunctions • (TIER-2) • (CODE-TABS) •
(0022) HandyToolBarGradient(HNDTools) 1 © CHT HandyToolBarGradient • (TIER-2) •
(0023) ProcedureImagesEx(HNDTools) 1 © CHT ProcedureImagesEx • (TIER-1) • (CODE-TABS) •
(0024) ProcedureSnapIns(HNDTools) 1 © CHT ProcedureSnapIns • (TIER-3) •
(0025) ResizeHandles(HNDTools) 1 © CHT ResizeHandles • (TIER-2) • (CODE-TABS) •
(10) Local Templates • (TIER-3)

Copyright © 1996-2023 - CHT Version: [27B.00.00]
Gus M. Creces, CLARION HANDY TOOLS
All Rights Reserved Worldwide

chtlogo001.gif
Application Templates