<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1">
<title>FreeTDS API: tds_dynamic Struct Reference</title>
<link href="doxygen.css" rel="stylesheet" type="text/css">
</head><body>
<!-- Generated by Doxygen 1.4.1 -->
<div class="qindex"><a class="qindex" href="index.html">Main Page</a> | <a class="qindex" href="modules.html">Modules</a> | <a class="qindex" href="annotated.html">Class List</a> | <a class="qindex" href="dirs.html">Directories</a> | <a class="qindex" href="files.html">File List</a> | <a class="qindex" href="functions.html">Class Members</a> | <a class="qindex" href="globals.html">File Members</a> | <a class="qindex" href="pages.html">Related Pages</a></div>
<h1>tds_dynamic Struct Reference</h1>Holds information for a dynamic (also called prepared) query.
<a href="#_details">More...</a>
<p>
<code>#include <<a class="el" href="a00311.html">tds.h</a>></code>
<p>
<a href="a00108.html">List of all members.</a><table border="0" cellpadding="0" cellspacing="0">
<tr><td></td></tr>
<tr><td colspan="2"><br><h2>Public Attributes</h2></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="o0" doxytag="tds_dynamic::dyn_state"></a>
int </td><td class="memItemRight" valign="bottom"><b>dyn_state</b></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a00141.html#o1">emulated</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">this dynamic query cannot be prepared so libTDS have to construct a simple query. <a href="#o1"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">char </td><td class="memItemRight" valign="bottom"><a class="el" href="a00141.html#o2">id</a> [30]</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">id of dynamic. <a href="#o2"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="o3" doxytag="tds_dynamic::next"></a>
<a class="el" href="a00141.html">tds_dynamic</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00141.html#o3">next</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">next in linked list, keep first <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="o4" doxytag="tds_dynamic::num_id"></a>
TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a00141.html#o4">num_id</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">numeric id for mssql7+ <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="el" href="a00143.html">TDSPARAMINFO</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00141.html#o5">params</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">query parameters. <a href="#o5"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="o6" doxytag="tds_dynamic::query"></a>
char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00141.html#o6">query</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">saved query, we need to know original query if prepare is impossible <br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="o7" doxytag="tds_dynamic::res_info"></a>
<a class="el" href="a00143.html">TDSPARAMINFO</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00141.html#o7">res_info</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">query results <br></td></tr>
</table>
<hr><a name="_details"></a><h2>Detailed Description</h2>
Holds information for a dynamic (also called prepared) query.
<p>
<hr><h2>Member Data Documentation</h2>
<a class="anchor" name="o1" doxytag="tds_dynamic::emulated"></a><p>
<table class="mdTable" cellpadding="2" cellspacing="0">
<tr>
<td class="mdRow">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="md" nowrap valign="top">int <a class="el" href="a00141.html#o1">tds_dynamic::emulated</a> </td>
</tr>
</table>
</td>
</tr>
</table>
<table cellspacing="5" cellpadding="0" border="0">
<tr>
<td>
</td>
<td>
<p>
this dynamic query cannot be prepared so libTDS have to construct a simple query.
<p>
This can happen for instance is tds protocol doesn't support dynamics or trying to prepare query under Sybase that have BLOBs as parameters. </td>
</tr>
</table>
<a class="anchor" name="o2" doxytag="tds_dynamic::id"></a><p>
<table class="mdTable" cellpadding="2" cellspacing="0">
<tr>
<td class="mdRow">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="md" nowrap valign="top">char <a class="el" href="a00141.html#o2">tds_dynamic::id</a>[30] </td>
</tr>
</table>
</td>
</tr>
</table>
<table cellspacing="5" cellpadding="0" border="0">
<tr>
<td>
</td>
<td>
<p>
id of dynamic.
<p>
Usually this id correspond to server one but if not specified is generated automatically by libTDS </td>
</tr>
</table>
<a class="anchor" name="o5" doxytag="tds_dynamic::params"></a><p>
<table class="mdTable" cellpadding="2" cellspacing="0">
<tr>
<td class="mdRow">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="md" nowrap valign="top"><a class="el" href="a00143.html">TDSPARAMINFO</a>* <a class="el" href="a00141.html#o5">tds_dynamic::params</a> </td>
</tr>
</table>
</td>
</tr>
</table>
<table cellspacing="5" cellpadding="0" border="0">
<tr>
<td>
</td>
<td>
<p>
query parameters.
<p>
Mostly used executing query however is a good idea to prepare query again if parameter type change in an incompatible way (ie different types or larger size). Is also better to prepare a query knowing parameter types earlier. </td>
</tr>
</table>
<hr>The documentation for this struct was generated from the following file:<ul>
<li>/usr/local/users/home/jklowden/projects/releases/freetds/0.82/include/<a class="el" href="a00311.html">tds.h</a></ul>
<hr size="1"><address style="align: right;"><small>Generated on Wed May 7 19:22:10 2008 for FreeTDS API by
<a href="http://www.doxygen.org/index.html">
<img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.4.1 </small></address>
</body>
</html>
distrib
>
Mageia
>
1
>
i586
>
media
>
core-release
>
by-pkgid
>
f0bc842dcf666302badcfd2545f3387c
>
files
>
41
