At 03:27 PM 1/07/2003 +0000, you wrote:

>IB_SQL, Extract Metadata SQL, issues false warning.
>After extracting the metadata, for views,
>IB_SQL warns (on FB1.5,Rc3,Dialect3):
>
>View.T2_VYS_TEST_VERRECHNETE: DbKey_Length should be 8 but is 32
>but according to the fb developers, 32 is correct ?

Frank,
I was watching your messages in fb-devel and came to the conclusion that
you are getting this warning from ib_sql because it has no way to know that
your view is a join of four tables, and not a table.

The statement object can calculate the expected size of the rdb$db_key
correctly if it knows about joins, e.g. if your client dsql had three JOIN
clauses, it would have calculated 8 bytes for the left-hand table and 8 for
each other table from left to right.

I can't see why this should be a problem - a warning isn't an error - and
the 32-byte rdb$db_key is still unique.

regards,
Helen