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]