Re: Cascade Deletes not working!!!

In article <5i9psj$j2h@news.asu.edu>, walker@imap1.asu.edu wrote: >Hello everybody... <snip> >....and yet when I run a simple delete query like: > >delete from Products where productId = 'abc123' I get the following>message from dbaccess: > > 692: Key value for constraint (walker.u107_11) is still being referenced.> >That's supposed to delete the record in Products and then delete the >corresponding row from Attributes, right? I don't understand! > Hi Robin, The database must support transactions for a cascade to occur since the all the deletions need to be done in a transaction. Turn on logging for your database and cascades should work. Of course, the clarity of the error message informix generates is excruciatingly precise, isn't it? :) HTH. ----------------------- Rudy Fernandes GIC, Kuwait OL 7.20UC4, 4GL 6.04UC1 -----------------------