[Lazarus] What is a TSQLTransaction and why do I need one?

Alexsander Rosa alexsander.rosa at gmail.com
Wed Nov 24 18:52:11 CET 2010

Implicit transaction even in C using libpq, even for a mere SELECT? Are you

2010/11/23 Mark Morgan Lloyd <markMLl.lazarus at telemetry.co.uk>

> Martin Schreiber wrote:
>> On Tuesday, 23. November 2010 18.01:35 Alexsander Rosa wrote:
>>> I think the statement "without a transaction, Postgres will do nothing,
>>> ever". For example: you can write a small C program using libpq that
>>> executes a simple SELECT without any transaction SQL code. Here's a
>>> comment
>> [...]
>> It uses an implicit transaction. MSEgui version of tsqltransaction has the
>> flag tao_fake in options property which enables implicit transactions for
>> database connections which support them, for Firebird it is not supported.
>> MSEgui version of tsqldataset has the flag dso_offline which disconnects
>> from transaction after loading the data. It is possible to reconnect in
>> order to write the update packages to database.
> Thanks Martin, noted.
> --
> Mark Morgan Lloyd
> markMLl .AT. telemetry.co .DOT. uk
> [Opinions above are the author's, not those of his employers or colleagues]
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Alexsander da Rosa
Linux User #113925

"Extremismo na defesa da liberdade não é defeito.
Moderação na busca por justiça não é virtude."
-- Barry Goldwater
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20101124/5e7b5c5a/attachment-0003.html>

More information about the Lazarus mailing list