ASqlHandles Function | |
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.19
Syntax FUNCTION ASqlHandles(
ArrayName AS ARRAY,
nStatementHandle AS USUAL
) AS DWORD
public static uint ASqlHandles(
Array ArrayName,
[DefaultParameterValueAttribute(0, 1)] Usual nStatementHandle
)
Request Example
View SourceParameters
- 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