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
>