📄 command_param.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::Param</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>
<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.html" style ="TEXT-DECORATION: none"><h3>Class Members</h3></A>
</td>
<td align=left > <A href="Command_Examples.html#Param" style ="TEXT-DECORATION: none"><h3>Examples</h3></A>
</td>
</tr>
<tr>
<td colspan=3><h1>SACommand::Param</h1></td>
</tr>
</table>
<P><font face="Arial"><B>SAParam & Param(
int</B>
nParamByID<B> );<BR>throw
(SAException);</B></font></P>
<P><font face="Arial">
<B>
</B></font><font face="Arial"><B>SAParam & Param( const SAString
&</B>sParamByName<B>
</B>
<B> );<BR>throw
(SAException);</B></font></P>
<P>Returns the command parameter specified by its position or
name.
</P>
<H3>Parameters</H3>
<p><EM>nParamByID</EM>. A position of parameter
specified in the command text. Normally position is a number stated
in the command text after a colon (for example, 1
for :1, 5 for
:5).</p>
<p><EM>sParamByName</EM>. A string that represents
a name of the requested parameter. Normally name is a string stated
in the command text after a colon (for example, 'city' for :city,
'my city' for :"my city") or a parameter name
in a stored procedure or
function.</p>
<H3>Return value</H3>
<P>A reference to a <STRONG>SAParam</STRONG>
object.
</P>
<h3>Remarks</h3>
<P>Use <STRONG>Param</STRONG>
method to access
a parameter by its name or position (in SQL statement). If, for
example, you want to walk through all the parameters use <A
href="Command_ParamByIndex.html">ParamByIndex</A>
method.
</P>
<P>If parameters were not created before
calling
<STRONG>Param</STRONG>
method the Library creates
them implicitly (can query native API if needed and therefore can
throw exception
on error) and then returns the specified parameter.
</P>
<P> Passing a value of name or
position which does not specified in
the command text will throw an exception.
</P>
<P><b>SAParam</b> object
contains full information about a parameter: name, type, size, etc.
Values for the input parameters can be assigned to
<STRONG>SAParam</STRONG>
object or supplied by <A
href="Command_operator_bind.html"
>operator <<</a>
.
</P>
<H3>Server specific notes</H3>
<P>No specific information.</P>
<H3>See also</H3>
<P>
<A href="Command_CreateParam.html" target="" >CreateParam</A>, <A
href="Command_ParamByIndex.html"
target="">ParamByIndex</A>,
<A
href="Command_ParamCount.html">ParamCount</A>
</P>
<P> <A href="Param.html" >SAParam</A>
</P>
<p><A href="../HowTo/errors.html" >Error
handling</A> </p>
<H3>Problems and Questions</H3>
<P> If
you don't find the answer to you 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 + -