--- In firebird-support@yahoogroups.com, 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,

inserted,

> 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.

Adam