ASQLHANDLES( ) Function
Stores numeric references to all active SQL connection statement handles in an array.
ASQLHANDLES(ArrayName [, nStatementHandle])
Parameters
ArrayName
Specifies the name of an array to store statement handle information.If the array you specify does not exist, Visual FoxPro creates the array automatically. If the array exists and is not large enough to store the information, Visual FoxPro increases the array size automatically. If the array is larger than necessary, Visual FoxPro truncates the array.
- nStatementHandle
Populates the array with statement handles that use the same shared connection, including nStatementHandle.
Return Value
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 Visual FoxPro 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
Reference
SQLGETPROP( ) Function
SQLSETPROP( ) Function
SQL Commands and Functions