Subject | RDB$SYSTEM_FLAG states |
---|---|
Author | Lester Caine |
Post date | 2004-04-20T19:40:39Z |
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?
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
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?
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services