> A little niggle has come up in ibWebAdmin.
>
> The RDB$SYSTEM_FLAG is used to establish various sets of information,
> and it is normally NULL for user records. The problem is that after some
> backup and restore cycles the field is becoming a '0'.
>
> What state SHOULD it be for 'non' system entries?
> or do we have to use
> WHERE ((RDB$SYSTEM_FLAG = 0) OR (RDB$SYSTEM_FLAG IS NULL))
> for all new systems?

Well, that's what I do.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com