Hi
We have serious problems deleting records, which we didn’t have in 5.2.10. And: Our application will be productive in two weeks:
-
We have a table courses and a table courseMembers. In courseMembers we store a foreign key to a course. The relation coursed_to_courseMembers does not allow parents to be deleted when having related records. If we “delete” a courseMember, we set the foreign key to null. But if a course is no longer referenced by any courseMember, we cannot delete the course. The relation coursed_to_courseMembers prevents the deletion. How can this be? Debugging this, shows us an empty foundset.
-
Deleting a course will delete the teachers quota, assigned to the course as well (defined by a relation courses_to_quotas, where we defined that related records should be deleted as well). I think, deleting a course should be one transaction: Delete the course and the quota. If something fails, nothing is done. But: The quota is deleted even if course deletion fails. This is wrong in my opinion.
-
Table event afterRecordDelete does not trigger (see http://www.servoy.com/forum/viewtopic.php?f=4&t=17391)
Servoy 5.2.11
Mac OS X 10.7.2
Java 1.6.0_29
SQLAnywhere12
Any help will be much appreciated. Regards