📄 command.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</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="../OnLineDoc/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>
<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>
</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_Examples.html" style="TEXT-DECORATION: none"><h3>Examples</h3></A>
</td>
</tr>
<tr>
<td colspan="2"><h1>SACommand</h1></td>
</tr>
</table>
<h3>Construction / Destruction</h3>
<table width="100%" cellspacing="2" cellpadding="10">
<tr>
<td width="30%" valign="top">
<A href="Command_cnstr.html">
<font face="Arial" size="3">
SACommand</font></A></td>
<td> <font face="Arial" size="3">
Constructs a <b>SACommand</b> object</font></td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_dstr.html">
<font face="Arial" size="3">
~SACommand</font></A></td>
<td> <font face="Arial" size="3">
Destructs a <b>SACommand</b> object</font></td>
</tr>
<tr><td colspan="2"><hr></td></tr>
</table>
<h3>Methods</h3>
<table width="100%" cellspacing="2" cellpadding="10">
<tr>
<td width="30%" valign="top">
<A href="Command_Connection.html">
<font face="Arial">
Connection </font></A></td>
<td><font face="Arial" size="3">
Returns a pointer to the current <A href="Connection.html">SAConnection</A>
object</font></td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_setConnection.html">
<font face="Arial">
setConnection </font></A></td>
<td><font face="Arial" size="3">
Associates a command with an existing <A href="Connection.html">SAConnection</A>
object</font></td>
</tr>
<tr><td colspan="2"><hr></td></tr>
<tr>
<td width="30%" valign="top">
<A href="Command_Open.html"><font face="Arial">
Open </font> </A></td>
<td> <font face="Arial">
Opens a command</font></td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_isOpened.html"><font face="Arial">
isOpened </font></A> </td>
<td><font face="Arial">
Tests whether a command is opened</font></td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_Close.html"><font face="Arial">
Close </font></A> </td>
<td><font face="Arial">
Closes a command </font></td>
</tr>
<tr><td colspan="2"><hr></td></tr>
<tr>
<td width="30%" valign="top">
<A href="Command_setCommandText.html"><font face="Arial">
setCommandText </font></A> </td>
<td><font face="Arial">
Sets command text </font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_CommandText.html"><font face="Arial">
CommandText </font></A> </td>
<td><font face="Arial">
Returns a command text </font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_CommandType.html"><font face="Arial">
CommandType </font></A> </td>
<td><font face="Arial">
Returns a command type </font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_Prepare.html"><font face="Arial">
Prepare </font></A> </td>
<td><font face="Arial">
Prepares command before execution</font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_Execute.html"><font face="Arial">
Execute </font></A> </td>
<td><font face="Arial">
Executes command</font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_isResultSet.html"><font face="Arial">
isResultSet </font></A> </td>
<td><font face="Arial">
Tests whether a result set
exists after the last command execution</font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_RowsAffected.html"><font face="Arial">
RowsAffected </font></A> </td>
<td><font face="Arial">
Returns number
of rows affected by the last command execution</font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_FetchNext.html"><font face="Arial">
FetchNext </font></A> </td>
<td><font face="Arial" size="3">
Fetches next row from a result set</font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_Cancel.html"><font face="Arial">
Cancel </font></A> </td>
<td><font face="Arial" size="3">
Attempts to cancel the pending
result set, or current statement execution</font> </td>
</tr>
<tr><td colspan="2"><hr></td></tr>
<tr>
<td width="30%" valign="top">
<A href="Command_CreateParam.html"><font face="Arial">
CreateParam </font></A> </td>
<td><font face="Arial">
Creates parameter </font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_DestroyParams.html"><font face="Arial">
DestroyParams </font></A> </td>
<td><font face="Arial">
Destroys all parameters associated with the
<STRONG>SACommand</STRONG>
object</font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_ParamCount.html"><font face="Arial">
ParamCount </font></A> </td>
<td><font face="Arial">
Returns the number of bind variables for SQL
statement or stored procedure specified in the
<STRONG>SACommand</STRONG> object</font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_ParamByIndex.html"><font face="Arial">
ParamByIndex </font></A> </td>
<td><font face="Arial">
Returns the <A href="Param.html">SAParam</A> object by
index in params array</font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_Param.html"><font face="Arial">
Param </font></A> </td>
<td><font face="Arial">
Returns the <A href="Param.html">SAParam</A> object by
name or position specified in SQL statement</font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_operator_bind.html"><font face="Arial">
operator << </font></A> </td>
<td><font face="Arial">
Binds input parameters</font> </td>
</tr>
<tr><td colspan="2"><hr></td></tr>
<tr>
<td width="30%" valign="top">
<A href="Command_FieldCount.html"><font face="Arial">
FieldCount </font></A> </td>
<td><font face="Arial">
Returns the number of columns in result set</font></td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_Field.html"><font face="Arial">
Field </font></A> </td>
<td><font face="Arial">
Gets specified <A href="Field.html">SAField</A> object by
its name or position </font> </td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_operator_get.html"><font face="Arial">
operator [] </font></A> </td>
<td><font face="Arial">
Gets specified <A href="Field.html">SAField</A>
object by
its name or position - operator substitution for <A href="Command_Field.html">Field</A></font>
</td>
</tr>
<tr><td colspan="2"><hr></td></tr>
<tr>
<td width="30%" valign="top">
<A href="Command_setOption.html"><font face="Arial">
setOption </font></A> </td>
<td><font face="Arial">
Sets a string value of a specific command option</font></td>
</tr>
<tr>
<td width="30%" valign="top">
<A href="Command_Option.html"><font face="Arial">
Option </font></A> </td>
<td><font face="Arial">
Gets a string value of a specific command option</font></td>
</tr>
<tr><td colspan="2"><hr></td></tr>
<tr>
<td width="30%" valign="top">
<A href="Command_NativeHandles.html"><font face="Arial">
NativeHandles </font></A> </td>
<td><font face="Arial">
Gets native DBMS client command related handle(s)</font></td>
</tr>
</table>
</td>
<tr></tr>
</table>
</body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -