--- In firebird-support@yahoogroups.com, "Roberto Freitas"
<solanofreitas@...> wrote:

>
> Thank you, blescouet.
> What is CURRENT_VARIABLE please?

I think he was referring to the CURRENT_USER context variable. Inside
your trigger you can say

NEW.USER = CURRENT_USER;

etc.

Adam

>
> --- 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.
> >
>