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.19
SyntaxMembers| 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