> >>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.
>
> Yes - further investigation has shown that it is ALWAYS created with
> NULL for new entries. After a backup and restore it seems to be hit and
> miss as to whether it changes to '0'.
> The 'book' says it should be a '0', so perhaps this is one for the
> developers list? I'd prefer a little consistency :)

consistency - smonsistency?

:-)

I've never investigated the issue, just noticed it.


With regards,

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