Re: [GENERAL] Stuck on Foreign Keys

2007-09-24 Thread Benjamin Smith
On Wednesday 19 September 2007, Chester wrote: > Hi > > I have a question regarding foreign keys, I just cannot get it to create > them for meI must be doing something wrong but I have no idea what > that might be :) > > I have a table "clients" > > clientID (primary) > ticode > Firstname

Re: [GENERAL] Stuck on Foreign Keys

2007-09-20 Thread Phoenix Kiula
On 20/09/2007, Chester <[EMAIL PROTECTED]> wrote: > Hi > > I have a question regarding foreign keys, I just cannot get it to create > them for meI must be doing something wrong but I have no idea what > that might be :) > > I have a table "clients" > > clientID (primary) > ticode > Firstname >

Re: [GENERAL] Stuck on Foreign Keys

2007-09-19 Thread A. Kretschmer
am Thu, dem 20.09.2007, um 14:13:40 +1000 mailte Chester folgendes: > Hi > > I have a question regarding foreign keys, I just cannot get it to create > them for meI must be doing something wrong but I have no idea what > that might be :) > > I have a table "clients" > > clientID (primary)

Re: [GENERAL] Stuck on Foreign Keys

2007-09-19 Thread Chester
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

Re: [GENERAL] Stuck on Foreign Keys

2007-09-19 Thread Michael Glaesemann
On Sep 19, 2007, at 23:13 , Chester 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 error