The information in this article applies to:
SUMMARY
In Visual FoxPro, you can view the current property settings for a
connection by using the SQLGETPROP() command with the respective connection
handle. This article lists the connection properties that can be accessed
with SQLGETPROP() and shows how to use SQLGETPROP().
MORE INFORMATION
In Visual FoxPro, you can use SQLGETPROP() to display the information used
to create the active connection, to work with shared connections, to
control interface display and time intervals, and to fetch result sets into
view cursors. You can also use it to ensure that active connections are
deactivated after a specified time interval, to manage transactions, and to
display internal ODBC handles.
For example, the following command reads the setting for the "asynchronous"
connection property:
The nConnectionHandle parameter specifies the connection handle to the data
source returned by SQLCONNECT(). If you specify 0 for the active
connection, SQLGETPROP() returns the default setting. If a connection level
error occurs, -1 is returned. If an environment level error occurs, -2 is
returned.
The cSetting parameter specifies the setting. Connection Properties AvailableThe connection properties that can be accessed with SQLGETPROP() are listed below in functional groups.To display the information used to create the active connection:
NOTE: Documents that ship with the Professional Edition of Microsoft Visual
FoxPro version 3.0 for Windows and the Visual FoxPro Help file incorrectly
list the ConnectName property as being available with the SQLGETPROP()
function.
For more information about documentation error regarding the ConnectName property and the SQLGETPROP() function, please see the following article in the Microsoft Knowledge Base: Q137408 DOCERR: Can't Use ConnectName Property w/SQLGETPROP() FunctionTo work with shared connections:
To control interface display:
To control time intervals:
To qualify active connections are deactivated after a specified time
interval: (1)
To manage transactions:
To control fetching of result sets into view cursors:
To display internal ODBC handles:
NOTE: See SQLSETPROP() in the Visual FoxPro Help file for a list of the
settings you can set with the SQLSETPROP() function.
Additional query words: VFoxWin
Keywords : |
Last Reviewed: August 10, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |