Re: Stuck on Foreign Keys

Michael Glaesemann wrote:
>
> On Sep 19, 2007, at 23:13 , C wrote:
>
>> ERROR: insert or update on table "clients" violates foreign key
>> constraint "the_title"
>> DETAIL: Key (ticode)=( ) is not present in table "titles".
>>
>> Sorry, I have no idea where I am going wrong...Any help would be great
>
> You've shown us the errors but not the commands you used that threw
> the errors. Show us the exact commands you used along with the errors
> so we might see what's going wrong. It looks like you're not providing
> a value for ticode when inserting or updating clients, but that's just
> a guess.
>
> Michael Glaesemann
> grzm seespotcode net
>
>

Thanks Michael

The table's are existing populated table the error was happening
whilst altering the client table to add the FC, sorry if that was not
clear. Maurice put me right there were a couple of rows in the client
table with null values in the ticode column.

Thanks again guys

Cheers

C