Thank you, blescouet.
What is CURRENT_VARIABLE please?

--- In firebird-support@yahoogroups.com, "blescouet" <blescouet@...>
wrote:

>
> Hi,
>
> --- In firebird-support@yahoogroups.com, "Roberto Freitas"
> <solanofreitas@> wrote:
> >
> > Hello,
> > I use some applications that update records on a table in a

distributed

> > database (FireBird 1.5). This table has a Before Update trigger,

and

> > can be updated by different applications on different servers.

When

> > this trigger is fired, I must know (inside the trigger) what are
> > current server and application names.
> > How can I do it?
> >
>
> Creating reserved firebird users for each server and / or

application

> and testing the active user with the CURRENT_VARIABLE in the trigger
> could be a solution...
>
> B.L.
>