Subject Re: [ib-support] Can't insert foreign key constraint
Author Helen Borrie
At 04:47 PM 07-10-01 +0200, Carsten Schaefer wrote:

> > Carsten,
> > Has IBConsole by any chance created case-sensitive identifiers in your
>database? Does it work to add the constraint using the same case as was
>used for creating the table, i.e. F_ID_CHARGE.
> >
>
>Helen,
>I don't think this is the problem.
>(IBConsole shows all Metadata Uppercase)
>I tested it with F_ID_CHARGE without another result.
>(As i wrote:On another DB with same metadata but with much less data it
>works!)

Still, volume of metadata shouldn't make a difference.

Short of pumping the data into a fresh table, I don't know what to suggest.

rgds,
Helen

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