Click or drag to resize

Functions.ASqlHandles Method

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.18
 FUNCTION ASqlHandles(
	ArrayName AS ARRAY,
	 nStatementHandle AS USUAL
Request Example View Source


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.
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.
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