On 4/19/06, Michael Van Canneyt <[EMAIL PROTECTED]> wrote:
>
> SET TRANSACTION
>
> SELECT TRANSACTION NAME XYZ
Now I see it: the DML commands have a "transaction" clause that can be
specified ! Interesting . I hadn't known where to look in the
firebird doc,
and hadn't noticed this.
>
> Interbase has those too, but you can't do what I need with that:
> In a server app, have 1 connection and several independent transactions
> within that connection.
> You must take into account that most commercial engines require a per-user
> license, so connections are 'expensive'. 1 connection with separate
> transactions solves this problem. There is 1 connection, but each user
> is in a separate transaction...
Thanks for these clarifications. I've certainly found out new things today.
Cheers,
Adrian Maier
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives