Functions.SqlSetProp Method (Long, String, Usual)
FUNCTION SqlSetProp( nStatementHandle AS LONG, cSetting AS STRING, eExpression AS USUAL ) AS LONG
public static int SqlSetProp( int nStatementHandle, string cSetting, Usual eExpression )
|Asynchronous||Specifies whether result sets are returned synchronously (False (.F.), the default), or asynchronously (True (.T.)).||Read/write|
|BatchMode||Specifies whether SqlExec( ) returns result sets all at once (True (.T.), the default), or individually with SqlMoreResults( ) (False (.F.)).||Read/write|
|ConnectBusy||Contains True (.T.) if a shared connection is busy; otherwise contains False (.F.).||Read-only|
|ConnectString||The login connection string.||Read-only|
|ConnectTimeOut||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.||Read/write|
|DataSource||The name of the data source as defined in the ODBC.INI file for ODBC connections.||Read/write|
Specifies if a pending transaction is committed or rolled back when SqlDisconnect( ) is called for the last connection handle.|
The default is false (.F.), indicating that a pending transaction is committed when SqlDisconnect( ) is called for the last connection handle.
Specify true (.T.) to roll back a pending transaction when SqlDisconnect( ) is called for the last connection handle.
Connections with automatic transaction processing are not affected by this setting.
Contains a numeric value that determines when the ODBC Login dialog box is displayed. DispLogin may assume the following values:|
1 or DB_PROMPTCOMPLETE (from Foxpro.H).1 is the default.
2 or DB_PROMPTALWAYS (from Foxpro.H).
3 or DB_PROMPTNEVER (from Foxpro.H).
If 1 or DB_PROMPTCOMPLETE is specified, X# displays the ODBC Login dialog box only if any required information is missing.
If 2 or DB_PROMPTALWAYS is specified, the ODBC Login dialog box is always displayed, making it possible for you to change settings before connecting.
If 3 or DB_PROMPTNEVER is specified, the ODBC Login dialog box isn't displayed and X# generates an error if the required login information isn't available. Read/write.
|DispWarnings||Specifies if error messages are displayed (True (.T.)) or are not displayed (False (.F.), the default).||Read/write|
|IdleTimeout||The idle timeout interval in minutes. Active connections are deactivated after the specified time interval. The default value is 0 (wait indefinitely).||Read/write|
|ODBChdbc||The internal Ado.Net DbConnection object.||Read-only|
|ODBChstmt||The internal Ado.Net DbCommand object.||Read-only|
The size of the network packet used by the connection. Adjusting this value can improve performance.
The default value is 4096 bytes (4K).|
Changing this property does not work for all providers.
|Password||The connection password. When you create a connection with the Login dialog then this password is not always available.||Read-only|
|QueryTimeOut||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.||Read/write|
|Shared||Specifies whether the underlying connection is a shared connection (True (.T.)), or not (False (.F.)).||Read-only|
Contains a numeric value that determines how the connection manages transactions on the remote table. Transactions may assume the following values:|
1 or DB_TRANSAUTO (from Foxpro.H).1 is the default. Transaction processing for the remote table is automatically handled.
2 or DB_TRANSMANUAL (from Foxpro.H). Transaction processing is handled manually through SqlCommit( ) and SqlRollBack( ).
|UserId||The user identification. When you create a connection with the Login dialog then this UserId is not always available.||Read-only|
|WaitTime||The amount of time in milliseconds that elapses before X# checks if the SQL statement has completed executing. The default is 100 milliseconds.||Read/write|
1Close ALL 2Clear ALL 3Clear 4nHandle=SqlConnect() 5IF nHandle > 0 6nSet=SqlSetProp(nHandle, "PacketSize", 2048 ) 7IF nSet > 0 8=MessageBox("PacketSize was set to 2048",0,"Connection Results") 9ELSE 10=MessageBox("Error setting PacketSize",0,"Connection Results") 11ENDIF 12ELSE 13=MessageBox("No Connection",0,"Connection Results") 14ENDIF 15=SqlDisconnect(nHandle)