Ann,

no I haven't :)). In IB LogManager I want to permit the user-defined
determination of trigger positions for logging triggers. And one
option is to make sure that the logging trigger is fired at least
(pos=32767)!

Thomas

--- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:
> At 08:47 PM 10/5/2001 +0000, Thomas Steinmaurer wrote:
> >Hi all,
> >the max. trigger position in an IB6 database is 32767. Is there a
> >difference in a IB4.x/IB5.x/Firebird database?
>
> No, that's what the system tables can represent. I suppose you
could
> start at -32768 and work up from there, giving you 64535 before
action
> triggers and 64535 after action triggers for each of the three
trigger
> types for each table and view. Please tell me that you don't have
more
> than ten or twenty thousand triggers on any one table!
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.