JavaScript Editor js editor     Web development 

Main Page

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

ASQLHANDLES(ArrayName [, nStatementHandle])



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.

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.


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

JavaScript Editor js editor     Web development