| Subject | Re: [firebird-support] Question: RDB$SYSTEM_FLAG = 0 No Results |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2019-02-26T17:31:25Z |
On 26-2-2019 18:04, Robert Tulloch tultalk@... [firebird-support]
wrote:
`RDB$SYSTEM_FLAG IS NULL` for your query to return non-system indexes,
and that is because the flag is 1 for system, and null for non-system on
that version, and as far as I know that was inherited from InterBase 6.
I believe that was eventually fixed in Firebird 2.0 or 2.1.
Mark
PS Why even bother with a 19 year old version though?
--
Mark Rotteveel
wrote:
> Thanks.I don't have InterBase 6, but I tried on Firebird 1.5, and I have to use
> I checked the value and it is indeed 0
>
> I assume I can't attach a screen shot otherwise I would.
>
> Did you try running the query on your system to see if it works?
`RDB$SYSTEM_FLAG IS NULL` for your query to return non-system indexes,
and that is because the flag is 1 for system, and null for non-system on
that version, and as far as I know that was inherited from InterBase 6.
I believe that was eventually fixed in Firebird 2.0 or 2.1.
Mark
PS Why even bother with a 19 year old version though?
--
Mark Rotteveel