https://modiki.civfanatics.com/index.php?action=history&feed=atom&title=DB.StatementSQL_%28Civ5_API%29 2026-05-02T00:22:18Z Revision history for this page on the wiki MediaWiki 1.43.1 https://modiki.civfanatics.com/index.php?title=DB.StatementSQL_(Civ5_API)&diff=10852&oldid=prev 2012-09-19T18:33:21Z

<p>Bot update</p> <p><b>New page</b></p><div>{{Civ5 API Beta Banner}}<br /> &#039;&#039;This page is a part of the [[Lua and UI Reference (Civ5)]].&#039;&#039;&lt;br/&gt;<br /> <br /> <br /> <br /> {{TypeInfos5|Function.png|This function is a member of {{Type5|DB}}.&lt;br/&gt;<br /> This is a static method, invoke it with a dot.<br /> }}<br /> <br /> <br /> Returns the SQL string for the specified active SQL query index<br /> Used as a debug mechanism, returns the SQL text used for a specific active SQL query index.<br /> <br /> <br /> =Usage=<br /> &lt;code&gt;&#039;&#039;&#039;string&#039;&#039;&#039; DB.StatementSQL&lt;b&gt;(&lt;/b&gt;&#039;&#039;&#039;int&#039;&#039;&#039; statement_index&lt;b&gt;)&lt;/b&gt;&lt;/code&gt;<br /> <br /> <br /> &#039;&#039;&#039;Returned Value&#039;&#039;&#039;<br /> :The SQL string for an active command or nil.<br /> &#039;&#039;&#039;Parameters&#039;&#039;&#039;<br /> :{|<br /> |-<br /> |valign=&quot;top&quot; style=&quot;padding-right:6px;&quot;|statement_index:<br /> |valign=&quot;top&quot;| &#039;&#039;A 0-based index for the current active SQL commands. Use {{Func5|DB|StatementCount}} to obtain the number of active commands.&#039;&#039;<br /> |}<br /> <br /> <br /> =Examples=<br /> &lt;syntaxhighlight lang=&quot;lua&quot; class=&quot;civ5-example&quot;&gt;<br /> -- Print all active SQL statements.<br /> for idx = 0, DB.StatementCount() - 1, 1 do<br /> print(DB.StatementSQL(idx);<br /> end&lt;/syntaxhighlight&gt;<br /> <br /> <br /> {{Civ5 API Footer}}<br /> [[Category:Civ5 Methods and Functions|StatementSQL]]</div>

DonQuich