Difference between revisions of "SQLSETPROP()"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 33: | Line 33: | ||
|BatchMode||True (.T.)||No||Determines whether results sets are returned all at once (.T.) or one at a time using [SQLMORERESULTS()] (.F.) | |BatchMode||True (.T.)||No||Determines whether results sets are returned all at once (.T.) or one at a time using [SQLMORERESULTS()] (.F.) | ||
|- | |- | ||
− | |ConnectBusy||||Yes||.T. = Shared connection is busy | + | |valign=top|ConnectBusy||||valign=top|Yes||.T. = Shared connection is busy |
.F. = Shared connection is not busy | .F. = Shared connection is not busy | ||
|- | |- | ||
Line 42: | Line 42: | ||
|DataSource||||No||Data source name as specified in ODBC.INI | |DataSource||||No||Data source name as specified in ODBC.INI | ||
|- | |- | ||
− | |DispLogin||1||No||1 = The Login dialog box is displayed if any required information is missing | + | |valign=top|DispLogin||valign=top|1||valign=top|No||1 = The Login dialog box is displayed if any required information is missing |
2 = The Login dialog box is always displayed | 2 = The Login dialog box is always displayed | ||
3 = The Login dialog box is never displayed and an error is generated if any required information is missing | 3 = The Login dialog box is never displayed and an error is generated if any required information is missing | ||
|- | |- | ||
− | |DispWarnings||False (.F.)||No||.T. = Error messages are displayed | + | |valign=top|DispWarnings||valign=top|False (.F.)||valign=top|No||.T. = Error messages are displayed |
.F. = Error messages are not displayed | .F. = Error messages are not displayed | ||
|- | |- | ||
Line 64: | Line 64: | ||
.F. = Connection is not shared | .F. = Connection is not shared | ||
|- | |- | ||
− | |Transactions||1||No||1 = Automatic transaction handling | + | |valign=top|Transactions||valign=top|1||valign=top|No||1 = Automatic transaction handling |
2 = Manual transaction handling using [SQLCOMMIT()] and [SQLROLLBACK()] | 2 = Manual transaction handling using [SQLCOMMIT()] and [SQLROLLBACK()] | ||
|- | |- |
Revision as of 10:24, 7 January 2013
Contents
Purpose
Set property settings for a connection
Syntax
SQLSETPROP(<nStatementHandle>, <cSetting> [, <eExpression>])
See Also
SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLDISCONNECT(), SQLERROR(), SQLEXEC(), SQLGETPROP(), SQLMORERESULTS(), SQLPREPARE(), SQLROLLBACK(), SQLSTRINGCONNECT(), SQLTABLES()
Description
The SQLSETPROP() function is used to set the property settings for a specified connection. The SQLSETPROP() function operates on the ODBC data source specified by <nStatementHandle>.
This function is not yet implemented.
Keywords | Description |
---|---|
nStatementHandle | The workarea in which the gateway data source is open |
cSetting | The property setting to set. Please see table below for available property settings |
eExpression | The value to be set. If this optional parameter is not specified, the property is set to its default value. Please see table below for available property settings values |
Property Settings:
Setting | Default | Read-only | Description |
---|---|---|---|
Asynchronous | False (.F.) | No | Determines whether results sets are returned synchronously (.F.) or asynchronously (.T.) |
BatchMode | True (.T.) | No | Determines whether results sets are returned all at once (.T.) or one at a time using [SQLMORERESULTS()] (.F.) |
ConnectBusy | Yes | .T. = Shared connection is busy
.F. = Shared connection is not busy | |
ConnectString | Yes | Login connection string | |
ConnectTimeOut | 15 | No | Determines the time to wait before generating a connection time-out error. (0 – 600 seconds) |
DataSource | No | Data source name as specified in ODBC.INI | |
DispLogin | 1 | No | 1 = The Login dialog box is displayed if any required information is missing
2 = The Login dialog box is always displayed 3 = The Login dialog box is never displayed and an error is generated if any required information is missing |
DispWarnings | False (.F.) | No | .T. = Error messages are displayed
.F. = Error messages are not displayed |
IdleTimeout | 0 (Wait indefinitely) | No | Determines the time to wait before terminating an idle connection (seconds) |
ODBChdbc | Yes | Internal ODBC connection handle | |
ODBChstmt | Yes | Internal ODBC connection handle | |
PacketSize | 4K | No | Determines the network packet size used |
Password | Yes | Login connection password | |
QueryTimeOut | 0 (Wait indefinitely) | No | Determines the time to wait before generating a time-out error. (0 – 600 seconds) |
Shared | Yes | .T. = Connection is shared
.F. = Connection is not shared | |
Transactions | 1 | No | 1 = Automatic transaction handling
2 = Manual transaction handling using [SQLCOMMIT()] and [SQLROLLBACK()] |
UserId | Yes | Login connection user id | |
WaitTime | 100 milliseconds | No | Determines the time to wait before checking that an SQL statement has completed |
Return values:
Return Value | Description |
---|---|
1 | Property setting completed successfully |
–1 | Connection error |
–2 | Environment error |
Example
nStatHand = sqlconnect("awhr") if nStatHand < 1 messagebox("Could not connect") else nSetEnd = sqlsetprop(nStatHand,"Transactions",2) if nSetEnd = 1 messagebox("Manual Transactions Enabled") else messagebox("Unable to enable Manual Transactions") endif sqldisconnect(nStatHand) endif