At 10:54 PM 27-05-01 +0100, you wrote:

>Thanks for the info Ann. However it beings to look as if there *really* is an inconsistancy in the system tables.
>
>In rdb$types the value for an INT64 field (ie QUAD) is 9.
>
>However a field defined as say numeric(18) (ie an INT64 field) has a value of 16 in rdb$fields.rdb$field_type.
>
>16 does not appear in rdb$types.
>
>Thanks, Andy.

According to the ib6 docs, the field type enumeration is as follows:

•BLOB - 261
•CHAR - 14
•CSTRING - 40
•D_FLOAT - 11
•DOUBLE - 27
•FLOAT - 10
•INT64 - 16
•INTEGER - 8
•QUAD - 9
•SMALLINT - 7
•DATE - 12
(dialect 3 DATE)
•TIME - 13
•TIMESTAMP - 35
(DATE in older versions)
•VARCHAR - 37

There's an inconsistency somewhere. Here is the output from the same query, over a 5.6 database:

14 TEXT
7 SHORT
8 LONG
9 QUAD
10 FLOAT
27 DOUBLE
35 DATE
37 VARYING
261 BLOB
40 CSTRING
45 BLOB_ID

So - if QUAD is numeric(18,0), what was it doing in 5.6?

More puzzles...

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________