📄 command_cancel.html
字号:
<html>
<head>
<meta name="KEYWORDS" content=" library, C++, Oracle, SQLServer, DB2, Sybase, Informix, InterBase, SQLBase, ODBC,
SQL, server, client, database, programming, development, software,
Win32, Windows, Linux, Unix, Solaris,
Microsoft, Borland, Centura, Gupta, IBM"><meta name="DESCRIPTION" content=
"SQLAPI++ is C++ library for accessing SQL databases (Oracle, SQLServer, Sybase, DB2, InterBase, SQLBase, Informix, ODBC).
It uses native APIs, provides low-level access to database-specific features."><title>SQLAPI++ Library - Online Documentation - SACommand::Cancel</title>
</head>
<body bgcolor="#ffffff" BACKGROUND="../images/bg.gif" text="#000000"><!--GlbHdr--> <table WIDTH="600" height="40" frame="hsides" BORDER="2" BORDERCOLOR="#004fcd" align="right" cellpadding="0" cellspacing="2" id="TABLE1">
<tr><!--class="GlbDefault"-->
<td width="70" bgcolor="#000094" bordercolor="black" align="middle"><A href="../index.html" style="TEXT-DECORATION: none">
<font color="white" size="3" face="sans-serif">
<b>Home</b></font></A></td></TD>
<td width="70" bgcolor="#000094" bordercolor="black" align="middle"><A href="../HowTo/index.html" style="TEXT-DECORATION: none"> <font color="white" size="3" face="sans-serif">
<b>How To</b></font></A></td><!--class="GlbActive"-->
<td width="70" bgcolor="#00bb00" bordercolor="black" align="middle"><A href="index.html" style="TEXT-DECORATION: none"> <font color="white" size="3" face="sans-serif">
<b>Online Documentation</b></font></A></td><!--class="GlbDefault"-->
<td width="70" bgcolor="#000094" bordercolor="black" align="middle"><A href="../Support/index.html" style="TEXT-DECORATION: none"> <font color="white" size="3" face="sans-serif">
<b>Support</b></font></A></td>
<td width="70" bgcolor="#000094" bordercolor="black" align="middle">
<A href="../Download/index.html" style="TEXT-DECORATION: none">
<font color="white" size="3" face="sans-serif">
<b>Download</b></font></A></td>
<td width="70" bgcolor="#000094" bordercolor="black" align="middle"><A href="../Order/index.html" style="TEXT-DECORATION: none"> <font color="white" size="3" face="sans-serif">
<b>Order</b></font></A></td> </tr>
</table>
<p> </p>
<table width="100%">
<tr>
<td valign="top" width="165"><!--LeftMenu-->
<table frame="void" CELLSPACING="5" width="165">
<tr><td><p> </p></td>
</tr>
<tr>
<td><img align="middle" src="../images/red.gif" WIDTH="12" HEIGHT="12">
<A href="Command.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
SACommand</A> </FONT> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="Connection.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
SAConnection</A> </FONT> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="Exception.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
SAException</font></A> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="Field.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
SAField</A> </FONT> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="Param.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
SAParam</A> </FONT> </td>
</tr>
<tr><td><hr></td></tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="String.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
SAString</A> </FONT> </td>
</tr>
<tr>
<td><img align="middle" src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="DateTime.html" style="TEXT-DECORATION: none">
<font color="white" size="2" face="sans-serif">
SADateTime</A> </FONT> </td>
</tr>
<tr>
<td><img align=middle src="../images/green.gif" WIDTH="12" HEIGHT="12">
<A href="Numeric.html" style ="TEXT-DECORATION: none" >
<font color=white size=2 face=sans-serif>
SANumeric</A> </FONT> </td>
</tr>
<tr><td><hr></td></tr>
<tr>
<td>
<A href="Enums.html" style ="TEXT-DECORATION: none" >
<font color=white size=2 face=sans-serif>
Enums and Typedefs</A> </FONT> </td>
</tr>
</table>
</td><!--empty column-->
<td width="20">
<p> </p>
</td><!--Content-->
<td valign="top" align="left">
<table width="100%" cellspacing="2" cellpadding="2">
<tr>
<td align="left">
<A href="Command_Usage.html" style="TEXT-DECORATION: none"><h3>Usage</h3></A>
</td>
<td align="left">
<A href="Command.html" style="TEXT-DECORATION: none"><h3>Class Members</h3></A>
</td>
<td align="left">
<A href="Command_Examples.html" style="TEXT-DECORATION: none"><h3>Examples</h3></A>
</td>
</tr>
<tr>
<td colspan="3"><h1>SACommand::Cancel</h1></td>
</tr>
</table>
<p><b><font face="Arial">void Cancel( );<br>
throw (SAException);</font></b></p>
<p> Attempts to cancel the pending result set, or
current statement execution. The exact definition
is vendor-dependent.
</p>
<h3>Remarks</h3>
<P><B>Cancel</B> can cancel the following types of processing on a
statement:
<UL type=disc>
<LI>A function running asynchronously on the statement.<BR>
<LI>A function running on the statement on another thread.
</LI></UL>
<p> After an application calls a function
asynchronously, it checks repeatedly to determine whether it
has finished processing. While the function is processing, an
application can call <B>Cancel</B> to cancel the
function.
</p>
<p> In a multithread application, the application
can cancel a function that is running synchronously on a
statement.
</p>
<h3>Server specific notes</h3>
<table width="100%" border=1 cellpadding=5>
<tr bgColor=#000094>
<td width=17%>
<p><STRONG><FONT color=white face="">DBMS
client</FONT> </STRONG></p></td>
<td >
<P><STRONG><FONT color=white face="">Specific
notes</FONT> </STRONG></P></td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/Oracle.html" title="Oracle server specific information">Oracle</A></STRONG></p>
</td>
<td>
<p>
SQLAPI++ calls
<STRONG>obreak</STRONG> function with Oracle 7 (OCI7) to
cancel a query. To get more details see
<STRONG>obreak</STRONG>
function description in Oracle
documentation.</p>
<p>
SQLAPI++ calls
<STRONG>OCIBreak</STRONG> function with Oracle 8 (OCI8)
to cancel a query. To get more details see
<STRONG>OCIBreak</STRONG>
function description in Oracle
documentation.</p>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/SQLServer_OleDb.html" title="SQL Server (OLE DB) specific information">SQL
Server (OLE DB)</A>
</STRONG> </p>
</td>
<td>
<p>
SQLAPI++ calls
<STRONG><STRONG>ICommand::Cance</STRONG>l</STRONG> function to cancel a query. To
get more details see <STRONG><STRONG>ICommand::Cancel</STRONG></STRONG>
function description in
SQL Server OLE DB
documentation.</p>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/SQLServer_DbLibrary.html" title="SQL Server (DB-Library) specific information">SQL
Server (DB-Library)</A>
</STRONG> </p>
</td>
<td>
<p>
SQLAPI++ calls
<STRONG>dbcancel</STRONG> function to cancel a query. To
get more details see <STRONG>dbcancel</STRONG> function
description in SQL Server documentation.<BR>To enable
cancellation you have to set
command option "UseDataReadyLoopOnExecute" to
"on".</p>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/Sybase.html" title="Sybase server specific information">Sybase</A></STRONG></p>
</td>
<td>
<P> Not supported.</P>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/DB2.html" title="DB2 server specific information">DB2</A></STRONG></p>
</td>
<td>
<p>
SQLAPI++ calls
<STRONG>SQLCancel</STRONG> function to cancel a query.
To get more details see <STRONG>SQLCancel</STRONG>
function description in DB2
documentation.</p>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/Informix.html" title="Informix server specific information">Informix</A></STRONG></p>
</td>
<td>
<p>
SQLAPI++ calls
<STRONG>SQLCancel</STRONG> function to cancel a query.
To get more details see <STRONG>SQLCancel</STRONG>
function description in Informix
documentation.</p>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/InterBase.html" title="InterBase server specific information">InterBase</A></STRONG></p>
</td>
<td>
<P> Not supported.</P>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/SQLBase.html" title="SQLBase server specific information">SQLBase</A></STRONG></p>
</td>
<td>
<p>
SQLAPI++ calls
<STRONG>sqlcan</STRONG> function to cancel a query. To
get more details see <STRONG>sqlcan</STRONG> function
description in SQLBase
documentation.</p>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/MySQL.html" title="MySQL server specific information">MySQL</A></STRONG></p>
</td>
<td>
<p>
SQLAPI++ calls <STRONG
>mysql_kill</STRONG> function to
cancel a query, and then calls <STRONG>mysql_ping</STRONG> function to restore connection
with server. To get more details see <STRONG
>mysql_kill</STRONG> and <STRONG
>mysql_ping</STRONG> functions
description in <STRONG>MySQL</STRONG>
documentation.</p>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/PostgreSQL.html" title="PostgreSQL server specific information">PostgreSQL</A></STRONG></p>
</td>
<td>
<p>
SQLAPI++ calls
<STRONG>PQrequestCancel</STRONG> function to cancel a query.
To get more details see <STRONG>PQrequestCancel</STRONG> function
description in <STRONG>PostgreSQL</STRONG>
documentation.</p>
</td>
</tr>
<tr>
<td>
<p><STRONG><A
href="../ServerSpecific/ODBC.html" title="ODBC server specific information">ODBC</A></STRONG></p>
</td>
<td>
<p>
SQLAPI++ calls
<STRONG>SQLCancel</STRONG> function to cancel a query.
To get more details see <STRONG>SQLCancel</STRONG>
function description in ODBC
documentation.</p>
</td>
</tr>
</table>
<h3>See also</h3>
<p><A href="../HowTo/errors.html">Error
handling</A> </p>
<h3>Problems and Questions</h3>
<p>
If
you haven't found the answer to your questions or
have some problems on using the Library, please, send e-mail to <A href="mailto:howto@sqlapi.com">howto@sqlapi.com</A>.
</p>
</td>
<tr></tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -