Let me explain what I'm trying to achieve; I'm new to Firebird and
I've not very clear this point.

I have several tables that gather information from the main tables of
database when a report is launched. In this process, first all the records
are deleted, then the new ones are inserted and finally several fields are
updated from other tables. Each of these actions is performed inside a
transaction (so, there are three transactions). My doubt is: if during this
whole process another user launches the same report with other parameters,
what will be the final state of the table? Maybe there will be a "mix" of
records of the several requests? So the idea is to isolate the whole
process of generating the report when the first user launches it and to
"lock" the other users while the process is running.

Regards

___________________________________________________________________________

Este mensaje se dirige exclusivamente a su destinatario y puede contener
información privilegiada o confidencial. Si no es vd. el destinatario
indicado, queda notificado de que la utilización, divulgación y/o copia sin
autorización está prohibida en virtud de la legislación vigente. Si ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma vía y proceda a su destrucción.


This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
___________________________________________________________________________