<?xml version="1.0" encoding="windows-1252"?>
<node id="992265" title="Re: Multiple SQL statements in DBI" created="2012-09-07 04:29:41" updated="2012-09-07 04:29:41">
<type id="11">
note</type>
<author id="5348">
Corion</author>
<data>
<field name="doctext">
&lt;p&gt;Your question 1 is answered by the likely fact that the statement sequence (as a whole) was either not executed until it parsed correctly, or was run in a transaction, and thus all modifications were rolled back.&lt;/p&gt;
&lt;p&gt;2. Executing multiple SQL statements in one &lt;c&gt;-&gt;do&lt;/c&gt; call is dependent on the database driver. I wouldn't rely on it.&lt;/p&gt;
&lt;p&gt;3. It depends on what the database driver implements. Ask the database vendor about the rationale.&lt;/p&gt;
</field>
<field name="root_node">
992255</field>
<field name="parent_node">
992255</field>
</data>
</node>
