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

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

How odd, this reply took 22 hours to come through from when I hit
send. I am not just replying to answered questions a day later. There
you go.

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