SQLProperty Enumeration | |
Enum that matches the various FoxPro Sql properties, used in SqlGetProp() and SqlSetProp()
Namespace:
XSharp.RDD
Assembly:
XSharp.Core (in XSharp.Core.dll) Version: 2.21
Syntax Members
| Member name | Value | Description |
---|
| Asynchronous | 0 | Specifies whether result sets are returned synchronously. |
| BatchMode | 1 | Specifies whether SqlExec( ) returns result sets all at once (True (.T.), the default),
or individually with SqlMoreResults( ) (False (.F.)). |
| ConnectBusy | 2 | Contains True (.T.) if a shared connection is busy; otherwise contains False (.F.). |
| ConnectString | 3 | The login connection string. |
| ConnectTimeOut | 4 | Specifies the time to wait (in seconds) before returning a connection time-out error.
If you specify 0, the wait is indefinite and a time-out error is never returned. ConnectTimeOut can be 0 to 600. The default is 15. |
| DataSource | 5 | The name of the data source as defined in the ODBC.INI file. |
| DisconnectRollback | 6 | Specifies if a pending transaction is committed or rolled back when SqlDisconnect( ) is called for the last connection handle. |
| DispLogin | 7 | Contains a numeric value that determines when the ODBC Login dialog box is displayed. |
| DispWarnings | 8 | Specifies if error messages are displayed (True (.T.)) or are not displayed (False (.F.), the default). |
| IdleTimeout | 9 | The idle timeout interval in minutes. Active connections are deactivated after the specified time interval.
The default value is 0 (wait indefinitely). |
| NativeCommand | 10 | The native commandtext in the SQLStatement object. |
| ODBChdbc | 11 | The internal ODBC connection, which may be used by external code to call ODBC. |
| ODBChstmt | 12 | The internal ODBC statement , which may be used by external code to call ODBC. |
| PacketSize | 13 | The size of the network packet used by the connection. Adjusting this value can improve performance.
The default value is 4096 bytes (4K). |
| Password | 14 | The connection password. |
| QueryTimeOut | 15 | Specifies the time to wait (in seconds) before returning a general time-out error.
If you specify 0 (the default), the wait is indefinite and a time-out error is never returned. QueryTimeOut can be 0 to 600. |
| Shared | 16 | Specifies whether the underlying connection is a shared connection (True (.T.)), or not (False (.F.)). |
| Transactions | 17 | Contains a numeric value that determines how the connection manages transactions on the remote table. |
| UserId | 18 | The user identification. |
| WaitTime | 19 | The amount of time in milliseconds that elapses before Visual FoxPro checks if the SQL statement
has completed executing. The default is 100 milliseconds. |
See Also