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

[Joost van der Sluis]

On Wed, 2010-11-24 at 17:40 -0200, Alexsander Rosa wrote:
> But it is transparent to the libpq programmer; why it's not
> transparent with sqldb?

To learn people that they have to use transactions. There are only a
very few cases in which you don't need a transaction.

But most programmers do a: not know how why transactions are there and
how they should be used, or b: are too sloppy to use them properly.

That most people do not understand what a transaction is and where it is
for, is demonstrated by you thinking that it was possible to do
something with Postgres without a transaction. For each transactional
database it is completely impossible to work without transactions. Or
else it woudn't be a transactional database anymore.

I tried to explain this to you earlier, but you preferred to use Zeos.
That's ok with me. But it would be better if you learn how to use
transactions properly. (With Zeos or sqldb, doesn't matter)

Joost.