<!-- This comment will put IE 6, 7 and 8 in quirks mode --> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> <title>FreeTDS API: tds_dynamic Struct Reference</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <link href="search/search.css" rel="stylesheet" type="text/css"/> <script type="text/javaScript" src="search/search.js"></script> <link href="doxygen.css" rel="stylesheet" type="text/css"/> </head> <body onload='searchBox.OnSelectItem(0);'> <!-- Generated by Doxygen 1.6.3 --> <script type="text/javascript"><!-- var searchBox = new SearchBox("searchBox", "search",false,'Search'); --></script> <div class="navigation" id="top"> <div class="tabs"> <ul> <li><a href="index.html"><span>Main Page</span></a></li> <li><a href="pages.html"><span>Related Pages</span></a></li> <li><a href="modules.html"><span>Modules</span></a></li> <li class="current"><a href="annotated.html"><span>Classes</span></a></li> <li><a href="files.html"><span>Files</span></a></li> <li> <div id="MSearchBox" class="MSearchBoxInactive"> <img id="MSearchSelect" src="search/search.png" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" alt=""/> <input type="text" id="MSearchField" value="Search" accesskey="S" onfocus="searchBox.OnSearchFieldFocus(true)" onblur="searchBox.OnSearchFieldFocus(false)" onkeyup="searchBox.OnSearchFieldChange(event)"/> <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a> </div> </li> </ul> </div> <div class="tabs"> <ul> <li><a href="annotated.html"><span>Class List</span></a></li> <li><a href="functions.html"><span>Class Members</span></a></li> </ul> </div> </div> <div class="contents"> <h1>tds_dynamic Struct Reference</h1><!-- doxytag: class="tds_dynamic" --> <p>Holds information for a dynamic (also called prepared) query. <a href="#_details">More...</a></p> <p><code>#include <<a class="el" href="a00159_source.html">tds.h</a>></code></p> <p><a href="a00410.html">List of all members.</a></p> <table border="0" cellpadding="0" cellspacing="0"> <tr><td colspan="2"><h2>Public Attributes</h2></td></tr> <tr><td class="memItemLeft" align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a00101.html#a73de21171e7d6fac5e38449bf1e9037d">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="#a73de21171e7d6fac5e38449bf1e9037d"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">char </td><td class="memItemRight" valign="bottom"><a class="el" href="a00101.html#a72332750aee80a0a94c92b35d7263d76">id</a> [30]</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">id of dynamic. <a href="#a72332750aee80a0a94c92b35d7263d76"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="adc93b94b6b4caf15dcf45297d928a8da"></a><!-- doxytag: member="tds_dynamic::next" ref="adc93b94b6b4caf15dcf45297d928a8da" args="" --> struct <a class="el" href="a00101.html">tds_dynamic</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00101.html#adc93b94b6b4caf15dcf45297d928a8da">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" align="right" valign="top"><a class="anchor" id="af6fd2355838cce1689fb0e04724b7b6a"></a><!-- doxytag: member="tds_dynamic::num_id" ref="af6fd2355838cce1689fb0e04724b7b6a" args="" --> TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a00101.html#af6fd2355838cce1689fb0e04724b7b6a">num_id</a></td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">numeric id for mssql7+ <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="el" href="a00118.html">TDSPARAMINFO</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00101.html#adba427a655336d0b128cdec36544464b">params</a></td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">query parameters. <a href="#adba427a655336d0b128cdec36544464b"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a1cee141e5f7045e691eec830cec1c158"></a><!-- doxytag: member="tds_dynamic::query" ref="a1cee141e5f7045e691eec830cec1c158" args="" --> char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00101.html#a1cee141e5f7045e691eec830cec1c158">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" align="right" valign="top"><a class="anchor" id="ac736e163c0d4cdbca980a861214d99e7"></a><!-- doxytag: member="tds_dynamic::res_info" ref="ac736e163c0d4cdbca980a861214d99e7" args="" --> <a class="el" href="a00118.html">TDSPARAMINFO</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a00101.html#ac736e163c0d4cdbca980a861214d99e7">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> <p>Holds information for a dynamic (also called prepared) query. </p> <hr/><h2>Member Data Documentation</h2> <a class="anchor" id="a73de21171e7d6fac5e38449bf1e9037d"></a><!-- doxytag: member="tds_dynamic::emulated" ref="a73de21171e7d6fac5e38449bf1e9037d" args="" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int <a class="el" href="a00101.html#a73de21171e7d6fac5e38449bf1e9037d">tds_dynamic::emulated</a></td> </tr> </table> </div> <div class="memdoc"> <p>this dynamic query cannot be prepared so libTDS have to construct a simple query. </p> <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. </p> </div> </div> <a class="anchor" id="a72332750aee80a0a94c92b35d7263d76"></a><!-- doxytag: member="tds_dynamic::id" ref="a72332750aee80a0a94c92b35d7263d76" args="[30]" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">char <a class="el" href="a00101.html#a72332750aee80a0a94c92b35d7263d76">tds_dynamic::id</a>[30]</td> </tr> </table> </div> <div class="memdoc"> <p>id of dynamic. </p> <p>Usually this id correspond to server one but if not specified is generated automatically by libTDS </p> </div> </div> <a class="anchor" id="adba427a655336d0b128cdec36544464b"></a><!-- doxytag: member="tds_dynamic::params" ref="adba427a655336d0b128cdec36544464b" args="" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="a00118.html">TDSPARAMINFO</a>* <a class="el" href="a00101.html#adba427a655336d0b128cdec36544464b">tds_dynamic::params</a></td> </tr> </table> </div> <div class="memdoc"> <p>query parameters. </p> <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. </p> </div> </div> <hr/>The documentation for this struct was generated from the following file:<ul> <li>/home/jklowden/releases/freetds-0.91/include/<a class="el" href="a00159_source.html">tds.h</a></li> </ul> </div> <!--- window showing the filter options --> <div id="MSearchSelectWindow" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" onkeydown="return searchBox.OnSearchSelectKey(event)"> <a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Defines</a></div> <!-- iframe showing the search results (closed by default) --> <div id="MSearchResultsWindow"> <iframe src="" frameborder="0" name="MSearchResults" id="MSearchResults"> </iframe> </div> <hr class="footer"/><address style="text-align: right;"><small>Generated on Wed Aug 17 22:22:36 2011 for FreeTDS API by <a href="http://www.doxygen.org/index.html"> <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.3 </small></address> </body> </html>