Re: Stuck on Foreign Keys

[Chester <chester(at)hica(dot)com(dot)au>]

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