Click or drag to resize

ASqlHandles Function

X#
Stores numeric references to all active SQL connection statement handles in an array.

Namespace:  XSharp.VFP
Assembly:  XSharp.VFP (in XSharp.VFP.dll) Version: 2.21
Syntax
 FUNCTION ASqlHandles(
	ArrayName AS ARRAY,
	 nStatementHandle AS USUAL
) AS DWORD
Request Example View Source

Parameters

ArrayName
Type: Array
Specifies the array to store statement handle information in. In contrary to VFP the array must exist when calling this function. If the array is not large enough to store the information, X# increases the array size automatically. If the array is larger than necessary, X# truncates the array.
nStatementHandle
Type: Usual
Populates the array with statement handles that use the same shared connection, including nStatementHandle.

Return Value

Type: DWord
Numeric. ASQLHandles( ) returns the number of statement handles in use. If no statement handles are available, ASQLHandles( ) returns 0 and does not modify the array.
Remarks
You can use references to statement handles in other X# SQL functions, such as SQLEXEC( ) and SQLDISCONNECT( ). For more information, see SQLEXEC( ) Function and SQLDISCONNECT( ) Function. You can create and return new statement handles using the SQLCONNECT( ) and SQLSTRINGCONNECT( ) functions. For more information, see SQLCONNECT( ) Function and SQLSTRINGCONNECT( ) Function.
See Also