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

Reply via email to