IB 6

Interesting:

If I run

select cast (RDB$RELATION_NAME as varchar(32)) AS TABLE_NAME, cast (RDB$INDEX_NAME as varchar(32)) AS INDEX_NAME, RDB$STATISTICS from rdb$indices where 0 = 0 AND RDB$SYSTEM_FLAG = 1 order by RDB$STATISTICS DESC

The result set is all the system tables. Running RDB$SYSTEM_FLAG = 0 returns zilch.

Makes NO sense.

I checked the RDB$SYSTEM_FLAG parameter and it is correct for the two different kinds of tables.

  • [firebird-support] ... Robert Tulloch tult...@hughes.net [firebird-support]
    • Re: [firebird-... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
      • Re: [fireb... Robert Tulloch tult...@hughes.net [firebird-support]
        • Re: [f... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
          • Re... Robert Tulloch tult...@hughes.net [firebird-support]
            • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
              • ... Robert Tulloch tult...@hughes.net [firebird-support]
                • ... hele...@iinet.net.au [firebird-support]
                • ... Robert Tulloch tult...@hughes.net [firebird-support]
                • ... hele...@iinet.net.au [firebird-support]
                • ... Robert Tulloch tult...@hughes.net [firebird-support]

Reply via email to