StatsWin

(ODBC Manager Library)

Description	Called to display a window showing current ODBC driver statistics for both the main driver and any user-selected IO device addresses
Returns	Nothing
Usage	Steady State only.
Related to:	AddConnection \| BuildDelete \| BuildInsert \| BuildSelect \| BuildUpdate \| ConvertToDbDate \| ConvertToDbTime \| ConvertToDbTimeStamp \| ConvertToVTSDate \| ConvertToVTSTime \| ConvertToVTSTimeStamp \| CopyRecords \| DBDropList \| DBGridList \| ErrMessage \| ExecuteQuery \| ExecuteQueryCached \| FlushCache \| FormatBatchQuery \| GetConnList \| ResultFormat \| StatsWin TableSynch \| Transaction \| TransactionCached
Format:	\ODBCManager\StatsWin( Enable, X, Y, ConnectionName)
Parameters

Enable

Required. Set to true to display the statistics window

Required. The screen X position of the window

Required. The screen Y position of the window

ConnectionName

Required. The name of the database connection to be shown.

Comments

This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager\, as shown in "Format" above.
The statistics shown in the window include the following:


Data Source	DSN
db State	dbState
Last Execution Time	ExecTime
Last Execution Date	ExecDate
Connection Time	Condt
Execution Time	Cmddt
Sem Q Time	Qdt
Average Execution Time	ACmddt
Average Sem Q Time	AQdt
Execution Count	ExecCount
Error Count	ErrCount
Recovery Count	RecoveryCount
db Open Count	OpenCount
db Close Count	CloseCount
Semaphore Count	SemCount
Error Code	Error
Error	Error
Error Time	ErrorTime
Error Date	ErrorDate
Error Query	ErrorQuery
ODBC Error Code	ODBCErrorCode
ODBC Error Current	ODBCErrorMsg
ODBC SQL State	ODBCSqlState
Last Error Code	LastError
Last Error	LastError
Last Error Query	LastErrorQuery
Last ODBC Error Code	LastODBCErrorCode
Last ODBC Error Current	LastODBCErrorMsg
Last ODBC SQL State	LastODBCSqlState