Subject Re: Foreign key violation, where there isn't
Author Adam
--- In, Sándor Tamás (HostWare Kft.)
<sandortamas@...> wrote:
> Thank you for your help.
> I've tried it with ISQL, watched carefully for the proper values,
> created, altered from scratch, and I've got the same result.
> When I try a joined select between the two table, it shows me the right
> values, FB can find the record. But then, when I try an 'alter
table' on the
> detail table, I got this FK violation error.
> Can it be a problem that I use a varchar field as primary, and
foreign key?

Why not provide this list with a sample sql script (no more than 100
lines) so we can see what you are talking about.