At 02:07 AM 25-04-02 +0200, Lele Gaifax wrote:

>No Helen, there are no DMLs at all there, only DDLs, in the specific
>just ALTER SP.

Then my next best guess is that you have > 255 changes to one of your
tables, and the error just happens to show up when you attempt to perform
*ANY* DDL.

What version of Firebird? Up until v.1, ALTER TRIGGER used to affect the
version count on the table...so, if you stepped up through server versions
without backing up and restoring, you might have some old version counts in
there that are close to the limit.

>BTW, I tend to avoid the IN() predicate if not just for quick
>interactive checks because it does not use indexes when used in the
>form IN( SELECT ... ).

Good. :))

>Is this still true with FB?

Yes, still true. IN() is handy, but it isn't designed for huge sets.

Cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________