Martijn Tonies wrote:

>>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 :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services