Difference between revisions of "SQLCANCEL()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Helen.george (Talk | contribs) |
||
| (10 intermediate revisions by 2 users not shown) | |||
| 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()]], [[SQLTRANSACTION()]] | |
| − | + | ||
==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" width="100%" | |
| − | {| class="wikitable" | + | !width="30%"|Keywords||width="70%"|Description |
| − | !Keywords||Description | + | |
|- | |- | ||
| − | |nStatementHandle|| | + | |nStatementHandle||Statement handle to the connection |
|- | |- | ||
|} | |} | ||
| − | + | The SQLCANCEL() function is included for syntax compatibility only. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | The SQLCANCEL() function is included for compatibility only. | + | |
| − | + | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | sqlcancel(nStathand) | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
</code> | </code> | ||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
| − | [[Category: | + | [[Category:ODBC Functions]] |
| + | [[Category:SQL Functions]] | ||
Latest revision as of 10:12, 31 January 2013
Contents
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(), SQLTRANSACTION()
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 | Statement handle to the connection |
The SQLCANCEL() function is included for syntax compatibility only.
Example
sqlcancel(nStathand)
