hmm, that's a pity. Thanks for the link. Is there a single query that could delete all my A's and B's? Or do I need to iterate through the A's and remove them all manually?
Richard On Aug 12, 5:52 pm, Yarko Tymciurak <[email protected]> wrote: > It apprears that sqlite does not support this - > seehttp://www.sqlite.org/omitted.html > > On Wed, Aug 12, 2009 at 2:41 AM, Richard <[email protected]> wrote: > > > hello, > > > Does sqlite support cascade or am I doing something wrong? > > > I have these tables: > > db.define_table('A', > > db.Field('B', db.B, ondelete='CASCADE'), > > ) > > db.define_table('B', > > db.Field('name'), > > ) > > > And when I run db(db.A.id > 0).delete(), the B's are still there. > > > Richard --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
