Subject Re: [firebird-support] Maximum size for trigger script?
Author Thomas Steinmaurer
> Brenden Walker wrote:
>
>>Thanks, we worked around the problem for now by dropping indenting and
>>extra spaces around operators (saved 10k on a 69k script). Not sure how
>>this type of thing would divide up, but certainly worth looking into.
>>
>
> So apparently the blr was smaller than the source - I'm not sure where
> the limit on the source comes from...

The maximum size of one SQL statement in Firebird counts here then.
AFAIR it is 64Kb.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com