[fpc-pascal] is this a bug?

[duilio foschi]

>Did Delphi use an auto-commit mode

I did some tests in old Delphi5: an exception is raised if I try to modify
the sql text of an open query.

This would help a lot in fpc, too.

Either the query is automatically closed or an exception should be raised.

The current behaviour of TQuery is error prone IMHO.

On Thu, Jun 3, 2021 at 10:32 AM Dennis Lee Bieber via fpc-pascal <
fpc-pascal at lists.freepascal.org> wrote:

> On Wed, 2 Jun 2021 13:00:12 +0200, duilio foschi via fpc-pascal
> <fpc-pascal at lists.freepascal.org> declaimed
> the following:
>
> >I am using  FPC v. 3.2.0 on both linux and windows.
> >
> >I use Firebird as a database (not sure that this is important).
> >
> >Say you write
> >
> >In order to get the expected results, I have to explicitly close the query
> >before re-assigning  AQuery.SQL.Text .
> >
> >I am sure that this did not happen in Delphi.
> >
>
>         Did Delphi use an auto-commit mode on database connections --
> meaning
> it closed transactions on each query?
>
>
> --
>         Wulfraed                 Dennis Lee Bieber         AF6VN
>         wlfraed at ix.netcom.com
> http://wlfraed.microdiversity.freeddns.org/
>
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20210603/9eca025c/attachment.htm>