| Subject | Re: Question: RDB$SYSTEM_FLAG = 0 No Results |
|---|---|
| Author | |
| Post date | 2019-02-27T23:38:38Z |
---In firebird-support@yahoogroups.com, <tultalk@...> wrote :
> Perhaps you missed my point or i missed yours.
You missed our point, I think. The user-defined tables in those old databases
have NULL in rdb$system_flag, which your Delphi-based GUI tool displays as zero.
To see the values correctly, you just need to query rdb$indices in isql, since it correctly
displays null as empty.
select RDB$RELATION_NAME,
RDB$INDEX_NAME,
RDB$SYSTEM_FLAG
from rdb$indices;
>I agree running NULL returns the user tables and no system table
which is what I wanted
>The fact that the flag on the user table is 0 and those tables are returned when NULL is used and not >when 0 is used was the question. So I guess it is a bug.
Yep, it's two bugs, really. The first in IB6, which didn't get around to writing zero in that flag for
non-system tables and the second in the particular VCL components used by your GUI tool, which
could not render null so rendered them as zero instead.