<div dir="ltr"><div dir="ltr"><div dir="ltr">>Did Delphi use an auto-commit mode</div><div dir="ltr"><br></div><div>I did some tests in old Delphi5: an exception is raised if I try to modify the sql text of an open query.<br></div><div><br></div><div>This would help a lot in fpc, too.</div><div><br></div><div>Either the query is automatically closed or an exception should be raised.</div><div><br></div><div>The current behaviour of TQuery is error prone IMHO. </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 3, 2021 at 10:32 AM Dennis Lee Bieber via fpc-pascal <<a href="mailto:fpc-pascal@lists.freepascal.org">fpc-pascal@lists.freepascal.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Wed, 2 Jun 2021 13:00:12 +0200, duilio foschi via fpc-pascal<br>
<<a href="mailto:fpc-pascal@lists.freepascal.org" target="_blank">fpc-pascal@lists.freepascal.org</a>> declaimed<br>
the following:<br>
<br>
>I am using FPC v. 3.2.0 on both linux and windows.<br>
><br>
>I use Firebird as a database (not sure that this is important).<br>
><br>
>Say you write<br>
><br>
>In order to get the expected results, I have to explicitly close the query<br>
>before re-assigning AQuery.SQL.Text .<br>
><br>
>I am sure that this did not happen in Delphi.<br>
><br>
<br>
Did Delphi use an auto-commit mode on database connections -- meaning<br>
it closed transactions on each query?<br>
<br>
<br>
-- <br>
Wulfraed Dennis Lee Bieber AF6VN<br>
<a href="mailto:wlfraed@ix.netcom.com" target="_blank">wlfraed@ix.netcom.com</a> <a href="http://wlfraed.microdiversity.freeddns.org/" rel="noreferrer" target="_blank">http://wlfraed.microdiversity.freeddns.org/</a><br>
<br>
_______________________________________________<br>
fpc-pascal maillist - <a href="mailto:fpc-pascal@lists.freepascal.org" target="_blank">fpc-pascal@lists.freepascal.org</a><br>
<a href="https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal" rel="noreferrer" target="_blank">https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal</a><br>
</blockquote></div></div>