JezK
Edit File: a01182.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://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=11"/> <meta name="generator" content="Doxygen 1.9.4"/> <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 id="projectrow"> <td id="projectalign"> <div id="projectname">FreeTDS API </div> </td> </tr> </tbody> </table> </div> <!-- end header part --> <!-- Generated by Doxygen 1.9.4 --> <script type="text/javascript"> /* @license magnet:?xt=urn:btih:d3d9a9a6595521f9666a5e94cc830dab83b65699&dn=expat.txt MIT */ var searchBox = new SearchBox("searchBox", "search",'Search','.html'); /* @license-end */ </script> <script type="text/javascript" src="menudata.js"></script> <script type="text/javascript" src="menu.js"></script> <script type="text/javascript"> /* @license magnet:?xt=urn:btih:d3d9a9a6595521f9666a5e94cc830dab83b65699&dn=expat.txt MIT */ $(function() { initMenu('',true,false,'search.php','Search'); $(document).ready(function() { init_search(); }); }); /* @license-end */ </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="a01179.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="a01182.html#details">More...</a></p> <p><code>#include <<a class="el" href="a00416_source.html">tds.h</a>></code></p> <div class="dynheader"> Collaboration diagram for tds_dynamic:</div> <div class="dyncontent"> <div class="center"><!-- SVG 0 --> </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 id="pub-attribs" name="pub-attribs"></a> Public Attributes</h2></td></tr> <tr class="memitem:a744986c76b9b09f29325a1e0664b0e9a"><td class="memItemLeft" align="right" valign="top"><a id="a744986c76b9b09f29325a1e0664b0e9a" name="a744986c76b9b09f29325a1e0664b0e9a"></a> bool </td><td class="memItemRight" valign="bottom"><b>defer_close</b></td></tr> <tr class="memdesc:a744986c76b9b09f29325a1e0664b0e9a"><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:a744986c76b9b09f29325a1e0664b0e9a"><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="a01182.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="a01182.html#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="a01182.html#a72332750aee80a0a94c92b35d7263d76">id</a> [30]</td></tr> <tr class="memdesc:a72332750aee80a0a94c92b35d7263d76"><td class="mdescLeft"> </td><td class="mdescRight">id of dynamic. <a href="a01182.html#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" name="adc93b94b6b4caf15dcf45297d928a8da"></a> struct <a class="el" href="a01182.html">tds_dynamic</a> * </td><td class="memItemRight" valign="bottom"><b>next</b></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" name="af6fd2355838cce1689fb0e04724b7b6a"></a> TDS_INT </td><td class="memItemRight" valign="bottom"><b>num_id</b></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="a01158.html">TDSPARAMINFO</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01182.html#adba427a655336d0b128cdec36544464b">params</a></td></tr> <tr class="memdesc:adba427a655336d0b128cdec36544464b"><td class="mdescLeft"> </td><td class="mdescRight">query parameters. <a href="a01182.html#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" name="a1cee141e5f7045e691eec830cec1c158"></a> char * </td><td class="memItemRight" valign="bottom"><b>query</b></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" name="a2798c66fb3c8637c7fb29c6d1efebfa4"></a> TDS_INT </td><td class="memItemRight" valign="bottom"><b>ref_count</b></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" name="ac736e163c0d4cdbca980a861214d99e7"></a> <a class="el" href="a01158.html">TDSPARAMINFO</a> * </td><td class="memItemRight" valign="bottom"><b>res_info</b></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" name="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" name="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" name="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="a01158.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="a00416_source.html">tds.h</a></li> </ul> </div><!-- contents --> <!-- start footer part --> <hr class="footer"/><address class="footer"><small> Generated by <a href="https://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.9.4 </small></address> </body> </html>