<!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"/> <meta http-equiv="X-UA-Compatible" content="IE=9"/> <meta name="generator" content="Doxygen 1.8.12"/> <meta name="viewport" content="width=device-width, initial-scale=1"/> <title>FreeTDS API: tds_dynamic Struct Reference</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript" src="dynsections.js"></script> <link href="search/search.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="search/searchdata.js"></script> <script type="text/javascript" src="search/search.js"></script> <link href="doxygen.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="top"><!-- do not remove this div, it is closed by doxygen! --> <div id="titlearea"> <table cellspacing="0" cellpadding="0"> <tbody> <tr style="height: 56px;"> <td id="projectalign" style="padding-left: 0.5em;"> <div id="projectname">FreeTDS API </div> </td> </tr> </tbody> </table> </div> <!-- end header part --> <!-- Generated by Doxygen 1.8.12 --> <script type="text/javascript"> var searchBox = new SearchBox("searchBox", "search",false,'Search'); </script> <script type="text/javascript" src="menudata.js"></script> <script type="text/javascript" src="menu.js"></script> <script type="text/javascript"> $(function() { initMenu('',true,false,'search.php','Search'); $(document).ready(function() { init_search(); }); }); </script> <div id="main-nav"></div> <!-- window showing the filter options --> <div id="MSearchSelectWindow" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" onkeydown="return searchBox.OnSearchSelectKey(event)"> </div> <!-- iframe showing the search results (closed by default) --> <div id="MSearchResultsWindow"> <iframe src="javascript:void(0)" frameborder="0" name="MSearchResults" id="MSearchResults"> </iframe> </div> </div><!-- top --> <div class="header"> <div class="summary"> <a href="#pub-attribs">Public Attributes</a> | <a href="a01162.html">List of all members</a> </div> <div class="headertitle"> <div class="title">tds_dynamic Struct Reference</div> </div> </div><!--header--> <div class="contents"> <p>Holds information for a dynamic (also called prepared) query. <a href="a01165.html#details">More...</a></p> <p><code>#include <<a class="el" href="a00434_source.html">tds.h</a>></code></p> <div class="dynheader"> Collaboration diagram for tds_dynamic:</div> <div class="dyncontent"> <div class="center"><iframe scrolling="no" frameborder="0" src="a01163.svg" width="1319" height="543"><p><b>This browser is not able to show SVG: try Firefox, Chrome, Safari, or Opera instead.</b></p></iframe> </div> <center><span class="legend">[<a href="graph_legend.html">legend</a>]</span></center></div> <table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-attribs"></a> Public Attributes</h2></td></tr> <tr class="memitem:a0c0907ff62841056a9c1e023d68eb0f0"><td class="memItemLeft" align="right" valign="top"><a id="a0c0907ff62841056a9c1e023d68eb0f0"></a> TDS_TINYINT </td><td class="memItemRight" valign="bottom"><a class="el" href="a01165.html#a0c0907ff62841056a9c1e023d68eb0f0">defer_close</a></td></tr> <tr class="memdesc:a0c0907ff62841056a9c1e023d68eb0f0"><td class="mdescLeft"> </td><td class="mdescRight">true if dynamic was marker to be closed when connection is idle <br /></td></tr> <tr class="separator:a0c0907ff62841056a9c1e023d68eb0f0"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ad3fedfbec2ba0db4a64b82779d95a0c5"><td class="memItemLeft" align="right" valign="top">TDS_TINYINT </td><td class="memItemRight" valign="bottom"><a class="el" href="a01165.html#ad3fedfbec2ba0db4a64b82779d95a0c5">emulated</a></td></tr> <tr class="memdesc:ad3fedfbec2ba0db4a64b82779d95a0c5"><td class="mdescLeft"> </td><td class="mdescRight">this dynamic query cannot be prepared so libTDS have to construct a simple query. <a href="#ad3fedfbec2ba0db4a64b82779d95a0c5">More...</a><br /></td></tr> <tr class="separator:ad3fedfbec2ba0db4a64b82779d95a0c5"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a72332750aee80a0a94c92b35d7263d76"><td class="memItemLeft" align="right" valign="top">char </td><td class="memItemRight" valign="bottom"><a class="el" href="a01165.html#a72332750aee80a0a94c92b35d7263d76">id</a> [30]</td></tr> <tr class="memdesc:a72332750aee80a0a94c92b35d7263d76"><td class="mdescLeft"> </td><td class="mdescRight">id of dynamic. <a href="#a72332750aee80a0a94c92b35d7263d76">More...</a><br /></td></tr> <tr class="separator:a72332750aee80a0a94c92b35d7263d76"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:adc93b94b6b4caf15dcf45297d928a8da"><td class="memItemLeft" align="right" valign="top"><a id="adc93b94b6b4caf15dcf45297d928a8da"></a> struct <a class="el" href="a01165.html">tds_dynamic</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01165.html#adc93b94b6b4caf15dcf45297d928a8da">next</a></td></tr> <tr class="memdesc:adc93b94b6b4caf15dcf45297d928a8da"><td class="mdescLeft"> </td><td class="mdescRight">next in linked list, keep first <br /></td></tr> <tr class="separator:adc93b94b6b4caf15dcf45297d928a8da"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:af6fd2355838cce1689fb0e04724b7b6a"><td class="memItemLeft" align="right" valign="top"><a id="af6fd2355838cce1689fb0e04724b7b6a"></a> TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a01165.html#af6fd2355838cce1689fb0e04724b7b6a">num_id</a></td></tr> <tr class="memdesc:af6fd2355838cce1689fb0e04724b7b6a"><td class="mdescLeft"> </td><td class="mdescRight">numeric id for mssql7+ <br /></td></tr> <tr class="separator:af6fd2355838cce1689fb0e04724b7b6a"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:adba427a655336d0b128cdec36544464b"><td class="memItemLeft" align="right" valign="top"><a class="el" href="a01141.html">TDSPARAMINFO</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01165.html#adba427a655336d0b128cdec36544464b">params</a></td></tr> <tr class="memdesc:adba427a655336d0b128cdec36544464b"><td class="mdescLeft"> </td><td class="mdescRight">query parameters. <a href="#adba427a655336d0b128cdec36544464b">More...</a><br /></td></tr> <tr class="separator:adba427a655336d0b128cdec36544464b"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a1cee141e5f7045e691eec830cec1c158"><td class="memItemLeft" align="right" valign="top"><a id="a1cee141e5f7045e691eec830cec1c158"></a> char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01165.html#a1cee141e5f7045e691eec830cec1c158">query</a></td></tr> <tr class="memdesc:a1cee141e5f7045e691eec830cec1c158"><td class="mdescLeft"> </td><td class="mdescRight">saved query, we need to know original query if prepare is impossible <br /></td></tr> <tr class="separator:a1cee141e5f7045e691eec830cec1c158"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a2798c66fb3c8637c7fb29c6d1efebfa4"><td class="memItemLeft" align="right" valign="top"><a id="a2798c66fb3c8637c7fb29c6d1efebfa4"></a> TDS_INT </td><td class="memItemRight" valign="bottom"><a class="el" href="a01165.html#a2798c66fb3c8637c7fb29c6d1efebfa4">ref_count</a></td></tr> <tr class="memdesc:a2798c66fb3c8637c7fb29c6d1efebfa4"><td class="mdescLeft"> </td><td class="mdescRight">reference counter so client can retain safely a pointer <br /></td></tr> <tr class="separator:a2798c66fb3c8637c7fb29c6d1efebfa4"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ac736e163c0d4cdbca980a861214d99e7"><td class="memItemLeft" align="right" valign="top"><a id="ac736e163c0d4cdbca980a861214d99e7"></a> <a class="el" href="a01141.html">TDSPARAMINFO</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01165.html#ac736e163c0d4cdbca980a861214d99e7">res_info</a></td></tr> <tr class="memdesc:ac736e163c0d4cdbca980a861214d99e7"><td class="mdescLeft"> </td><td class="mdescRight">query results <br /></td></tr> <tr class="separator:ac736e163c0d4cdbca980a861214d99e7"><td class="memSeparator" colspan="2"> </td></tr> </table> <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2> <div class="textblock"><p>Holds information for a dynamic (also called prepared) query. </p> </div><h2 class="groupheader">Member Data Documentation</h2> <a id="ad3fedfbec2ba0db4a64b82779d95a0c5"></a> <h2 class="memtitle"><span class="permalink"><a href="#ad3fedfbec2ba0db4a64b82779d95a0c5">§ </a></span>emulated</h2> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">TDS_TINYINT tds_dynamic::emulated</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 id="a72332750aee80a0a94c92b35d7263d76"></a> <h2 class="memtitle"><span class="permalink"><a href="#a72332750aee80a0a94c92b35d7263d76">§ </a></span>id</h2> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">char tds_dynamic::id[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 id="adba427a655336d0b128cdec36544464b"></a> <h2 class="memtitle"><span class="permalink"><a href="#adba427a655336d0b128cdec36544464b">§ </a></span>params</h2> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="a01141.html">TDSPARAMINFO</a>* tds_dynamic::params</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>include/freetds/<a class="el" href="a00434_source.html">tds.h</a></li> </ul> </div><!-- contents --> <!-- start footer part --> <hr class="footer"/><address class="footer"><small> Generated by  <a href="http://www.doxygen.org/index.html"> <img class="footer" src="doxygen.png" alt="doxygen"/> </a> 1.8.12 </small></address> </body> </html>