Can't delete records!

Classic Servoy
1

I am stuck on this one - I have at least 2 related tables in my solution and simply cannot delete records from them :( . This is just using a standard table view and manually using the Delete Record menu item - nothing happens! I have tried using a method and this returns false for controller.deleteRecord or foundset.deleteRecord. Delete All also fails.

I have created a new install of Servoy 3.5.1 and imported the solution (with data) and still no luck. I have connected to the solution using Sybase Central and deleted some rows there - they appear to go, but when I open the solution again in Servoy the rows are still there. I have tried re-synchronising the sequences on the tables - still no joy!

I can however create new rows and delete those with no problem :? If I try to Delete All with just the new records, it works - if the current set contains any of the old records nothing happens.

I believe the situation may have arisen through halting a method during bug testing when there was an open transaction, though I did not get any warning when I switched into and out of designer.

Any ideas gratefully received!

2

Did you check the server log, to see if there are errors reported ??

3

Are the records parents in an relation of which the “Allow parent delete when having related records”-checkbox in the relations dialog is unchecked?

4

Hi Hans,

No errors reported as a result of trying to delete the records, manually or by method.

Joas - you were right. There were 2 relationships where this was unchecked - shows how robust it is! Thanks for the help :D