Maybe RDB$SET_CONTEXT() and RDB$GET_CONTEXT() could be a solution for you....you can set your constants when you connect and their values will be available inside your triggers....or am I wrong?

Ionut




________________________________
From: svanderclock <svanderclock@...>
To: firebird-support@yahoogroups.com
Sent: Thu, 11 March, 2010 4:47:37 PM
Subject: [firebird-support] Re: constant un trigger/procedure


a little heavy to do all the time a select :( and also if you misspell the field name the result will be wrong

the purpose of the constant can be also that you can not delete it when it's is use in some trigger ...

--- In firebird-support@ yahoogroups. com, "Alan McDonald" <alan@...> wrote:
>
> >
> > hello,
> >
> > i don't like to see in trigger some code like
> > if xxx = 3 then ...
> > is it possible to declare global constant like
> >
> > Declare MyconstanteName INTEGER = 3;
> >
> > thanks by advance
> > stephane
> >
>
> you've got a database. Put the variable you want in a field and use a select
> statement anytime you want it.
> Alan
>







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