ASQLHANDLES( ) Function

  • Article

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

Other Resources

Functions