Re: [GENERAL] foreign key constraints, cannot delete [SOLVED]

2004-10-08 Thread Josh Close
On Fri, 8 Oct 2004 18:14:50 -0600, Michael Fuhr <[EMAIL PROTECTED]> wrote: > This looks like tblheadings has a foreign key reference to itself. > Is this the *exact* error message, cut-and-pasted? What do your > table definitions look like? > > -- > Michael Fuhr There isn't a foreign key referen

Re: [GENERAL] foreign key constraints, cannot delete

2004-10-08 Thread Michael Fuhr
On Fri, Oct 08, 2004 at 04:21:01PM -0500, Josh Close wrote: > On Fri, 8 Oct 2004 23:15:24 +0200, Martijn van Oosterhout > <[EMAIL PROTECTED]> wrote: > > You havn't posted the exact error message. You'll have to if you want > > people to properly explain what's going on... > > update or delete on "

Re: [GENERAL] foreign key constraints, cannot delete

2004-10-08 Thread Josh Close
On Fri, 8 Oct 2004 23:15:24 +0200, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > You havn't posted the exact error message. You'll have to if you want > people to properly explain what's going on... update or delete on "tblheadings" violates foreign key constraint "$1" on "tblheadings" DETAI

Re: [GENERAL] foreign key constraints, cannot delete

2004-10-08 Thread Martijn van Oosterhout
You havn't posted the exact error message. You'll have to if you want people to properly explain what's going on... On Fri, Oct 08, 2004 at 04:07:43PM -0500, Josh Close wrote: > How can a delete rows from a table that has foreign key constraints? > Here is how I have it set up. > > I have 2 table