Hi,

First of al I'm running 2.05 b11, maybe this has been fixed, my appologies. The problem occurs when you have some combination of constraints. Here is the script to create and do the test. After creating the database, please go to the table "subcat" and try to delete whatever row.

Regards,
Lucian

It's a client-server setup, if it makes a difference.
regards
Lucian

Lucian,

<< First of al I'm running 2.05 b11, maybe this has been fixed, my
appologies. The problem occurs when you have some combination of
constraints. Here is the script to create and do the test. After creating
the database, please go to the table "subcat" and try to delete whatever
row. >>

No, it's still in there.  The issue is with defining a foreign key that has
less columns than the primary/unique key of the target table of the foreign
key constraint.  In your particular case, it's the fkSub FK in the Stuff
table.

The workaround is "don't do that", and a fix will be in the next EDB build.

--
Tim Young
Elevate Software
www.elevatesoft.com

>The workaround is "don't do that", and a fix will be in the next EDB build.

Yeah, well ... I like to give you stuff to do

Regards
Lucian

Lucian,

<< Yeah, well ... I like to give you stuff to do >>

Well, if it helps, I really don't have a problem with "not enough to do".


--
Tim Young
Elevate Software
www.elevatesoft.com