Difference between revisions of "SQLCANCEL()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Request that an executing SQL statement be cancelled | Request that an executing SQL statement be cancelled | ||
| − | |||
==Syntax== | ==Syntax== | ||
SQLCANCEL(<nStatementHandle>) | SQLCANCEL(<nStatementHandle>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | + | [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLERROR()]], [[SQLEXEC()]], [[SQLGETPROP()]], [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLSTRINGCONNECT()]], [[SQLTABLES()]] | |
| − | + | ||
==Description== | ==Description== | ||
| Line 18: | Line 15: | ||
* SQLMORERESULTS() | * SQLMORERESULTS() | ||
* SQLTABLES() | * SQLTABLES() | ||
| − | |||
The SQLCANCEL() function operates on the data source specified by <nStatementHandle>. | The SQLCANCEL() function operates on the data source specified by <nStatementHandle>. | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 29: | Line 24: | ||
|- | |- | ||
|} | |} | ||
| − | |||
====Return values:==== | ====Return values:==== | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 45: | Line 38: | ||
|} | |} | ||
| − | + | The SQLCANCEL() function is included for compatibility only. | |
| − | The SQLCANCEL() function is included for compatibility only | + | |
| Line 66: | Line 58: | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
| − | |||
[[Category:ODBC Functions]] | [[Category:ODBC Functions]] | ||
[[Category:SQL Functions]] | [[Category:SQL Functions]] | ||
Revision as of 11:10, 7 December 2012
Purpose
Request that an executing SQL statement be cancelled
Syntax
SQLCANCEL(<nStatementHandle>)
See Also
SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLDISCONNECT(), SQLERROR(), SQLEXEC(), SQLGETPROP(), SQLMORERESULTS(), SQLPREPARE(), SQLROLLBACK(), SQLSETPROP(), SQLSTRINGCONNECT(), SQLTABLES()
Description
The SQLCANCEL() function is used to request that an executing SQL statement be cancelled. It can be used to cancel any of the following functions when they are running in asynchronous mode:
- SQLCOLUMNS()
- SQLEXEC()
- SQLMORERESULTS()
- SQLTABLES()
The SQLCANCEL() function operates on the data source specified by <nStatementHandle>.
| Keywords | Description |
|---|---|
| nStatementHandle | The workarea in which the gateway data source is open |
Return values:
| Return Value | Description |
|---|---|
| 1 | SQL statement was cancelled successfully |
| –1 | Connection error |
| –2 | Environment error |
The SQLCANCEL() function is included for compatibility only.
Example
nStatHand=SQLSTRINGCONNECT("rec@rec1:user1/pass1-/usr/recital/uas/data/southwind.tcpip",.T.) if nStatHand < 1 dialog box [Could not connect] else SQLSETPROP(nStatHand, "Asynchronous", .T.) SQLEXEC(nStatHand, "SELECT * from example") SQLCANCEL(nStathand) endif
Products
Recital, Recital Server
