Hi Martijn,

Martijn Tonies wrote:

>> I need to find out the current role from inside a trigger in IB 6... Is
>> that possible? If not (as I fear) can you think of any other way to set
>> a connection-local variable that will be visible from inside my trigger?
>>
>
> No and no.
>

I figured as much. I think I already looked into this a while ago, and
came to the same conclusion. By the way, do you know if anything like
this has been implemented in more recent versions of Interbase?

> Unless you would create a table that holds the "current role", which
> you set from your application.
>
> This - obviously - only works if you're using unique user names.
>

Yes, that would be a messy solution. The way I do it right now is simply
to use the user name instead of the role name as a means of
communicating information to my trigger. The ideal thing would be to be
able to set a connection variable that I could read from my triggers,
but that's not coming till FB 2.0 IIRC, right?

--
Best regards,
Jonathan Neve
_______________
CopyTiger - advanced database replicator for Interbase/Firebird!
Web : http://www.microtec.fr/copycat/ct
_______________________________________
CopyCat - database replication components for Delphi/C++Builder!
Web : http://www.microtec.fr/copycat/cc



[Non-text portions of this message have been removed]