# Can't delete records!

**URL:** <https://forum.servoy.com/t/cant-delete-records/8151>\
**Category:** Classic Servoy\
**Created:** [September 18, 2007, 12:33pm UTC](https://forum.servoy.com/t/cant-delete-records/8151 "2007-09-18T12:33:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![drookwood](https://avatars.discourse-cdn.com/v4/letter/d/ecae2f/32.png) [@drookwood](https://forum.servoy.com/u/drookwood)\
**Post date:** [September 18, 2007, 12:33pm UTC](https://forum.servoy.com/t/cant-delete-records/8151/1 "2007-09-18T12:33:09Z")

</div>

I am stuck on this one - I have at least 2 related tables in my solution and simply cannot delete records from them ![:(]( "Sad") . 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 ![:?]( "Confused") 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!

---

<div class="post-metadata">

**Author:** ![Hans\_Nieuwenhuis](https://avatars.discourse-cdn.com/v4/letter/h/87869e/32.png) [@Hans\_Nieuwenhuis](https://forum.servoy.com/u/Hans_Nieuwenhuis)\
**Post date:** [September 18, 2007, 1:12pm UTC](https://forum.servoy.com/t/cant-delete-records/8151/2 "2007-09-18T13:12:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Joas](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/joas/32/5095_2.png) [@Joas](https://forum.servoy.com/u/Joas)\
**Post date:** [September 18, 2007, 1:31pm UTC](https://forum.servoy.com/t/cant-delete-records/8151/3 "2007-09-18T13:31:11Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![drookwood](https://avatars.discourse-cdn.com/v4/letter/d/ecae2f/32.png) [@drookwood](https://forum.servoy.com/u/drookwood)\
**Post date:** [September 18, 2007, 1:48pm UTC](https://forum.servoy.com/t/cant-delete-records/8151/4 "2007-09-18T13:48:29Z")

</div>

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]( "Very Happy")
