I'm deploying a web2py app in GAE (web2py version 2.2.1) that has a number of tables with fields that reference other tables in the same model. I have a few pages that use the SQLFORM.grid to display the data from those tables. When running the app locally using sqlite as the backend everything works as it should and cascading deletes take place. When running under GAE cascading deletes don't work (I believe that's a GAE 'feature'). However I've tried setting my own 'ondelete' event in the SQLFORM.grid to manually delete dependent rows and while that event fires properly (I can see the logs) the dependent rows are never deleted. I have also tried setting 'ondelete=NO ACTION' in the model and issue a db.commit() at the end of the ondelete event.
What could be going on here? I would think the event trigger for ondelete should do the job but something must stop it from working. Should I stay away from SQLFORM.grid and try a different route to get around this GAE limitation? Thanks in advance, Julian --
