> > > Ive noticed this as well, never bothered investigating it
> > further though.
> > > If its reproducable like you say would be worth adding as a bug.
> >
> > Or at least, an "oddity".
>
> Not sure its an oddity, looking at IB6 langref the description is:
>
> RDB$SYSTEM_FLAG SMALLINT Indicates whether the procedure is:
> . User-defined (value of 0)
> . System-defined (value greater than 0)
>
> Every week or two the 'what does a null value mean' argument rises; NULL

is

> not defined, in that context its neither system nor user defined (imo).

Yeah, that could be true-ish.

> Of course, there could be more upto date info on system tables than what

I'm

> looking at, could be worth taking to fb-devel.

I noticed them being 0 or NULL before, just never noticed they changed :)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com