# rollBackEditedRecords

**URL:** <https://forum.servoy.com/t/rollbackeditedrecords/13220>\
**Category:** Classic Servoy\
**Created:** [November 22, 2010, 9:43pm UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220 "2010-11-22T21:43:19Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![lwjwillemsen](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/lwjwillemsen/32/4987_2.png) [@lwjwillemsen](https://forum.servoy.com/u/lwjwillemsen)\
**Post date:** [November 22, 2010, 9:43pm UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220/1 "2010-11-22T21:43:19Z")

</div>

I’ve noticed that in some cases a databaseManager.rollBackEditedRecords() deletes previously saved records ![:cry:]( "Crying or Very sad")

Step 1) insert some new records (A)  
2) databaseManager.saveData()  
3) databaseManager.setAutoSave(false)  
4) insert some new records (B)  
5) databaseManager.rollBackEditedRecords()  
6) databaseManager.setAutoSave(true)

Records **A** and B are gone after step 6. No Servoy database transactions are active.

Servoy Developer 5.2.2

Anyone seen this ?

Regards,

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [November 22, 2010, 10:15pm UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220/2 "2010-11-22T22:15:16Z")

</div>

Hi Lambert,

My guess is that in step 2 the saveDate() returned false and the records where not saved.  
Do you always check for the result ?

---

<div class="post-metadata">

**Author:** ![lwjwillemsen](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/lwjwillemsen/32/4987_2.png) [@lwjwillemsen](https://forum.servoy.com/u/lwjwillemsen)\
**Post date:** [November 23, 2010, 9:42pm UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220/3 "2010-11-23T21:42:59Z")

</div>

Hi Robert,

I went into debug mode : The saveData() of step 2 returns true, databaseManager.getEditedrecords() is empty after the save and I see the records (A) in the data SQL explorer (as it should after saveData()) !

After step 6 and refreshing the data SQL explorer the records (A) are gone… If I don’t use the rollbackEditedRecords() (step 5) everything is fine…

Quite disturbing. It looks like the internal Servoy administration of edited records is not (yet ?) correctly updated.

Regards,

---

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [November 24, 2010, 8:37am UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220/4 "2010-11-24T08:37:06Z")

</div>

That indeed doesn’t sound right. Can you file a case for this?

Paul

---

<div class="post-metadata">

**Author:** ![lwjwillemsen](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/lwjwillemsen/32/4987_2.png) [@lwjwillemsen](https://forum.servoy.com/u/lwjwillemsen)\
**Post date:** [November 24, 2010, 9:26am UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220/5 "2010-11-24T09:26:07Z")

</div>

Hi Paul,

Yep, Case ID 337601.

Regards,

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [November 24, 2010, 9:56am UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220/6 "2010-11-24T09:56:02Z")

</div>

Lambert,

There must be something else going on, because databasemanager.rollbackEditedrecords() does not delete anything in the db, it just reverts changes made in memory.

Rob

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [November 24, 2010, 10:14am UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220/7 "2010-11-24T10:14:08Z")

</div>

Hi Lambert,

Can you check that after step 2 that when it returns true the newly created records are really in the back-end database ?

---

<div class="post-metadata">

**Author:** ![lwjwillemsen](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/lwjwillemsen/32/4987_2.png) [@lwjwillemsen](https://forum.servoy.com/u/lwjwillemsen)\
**Post date:** [November 24, 2010, 1:48pm UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220/8 "2010-11-24T13:48:23Z")

</div>

Hi Robert,

Yes, they are present in de back-end database.

I filed a case but I don’t have the time to isolate the problem into a sample solution.  
I rewrote my code now so that I don’t have to use the rollbackEditedRecords() in step 5 (first test and if ok then write is BTW always better)

Thanks for thinking along with me.

Regards,

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [November 24, 2010, 2:49pm UTC](https://forum.servoy.com/t/rollbackeditedrecords/13220/9 "2010-11-24T14:49:46Z")

</div>

Hi Lambert,

Interesting…so they are in the database and then gets deleted. Are you sure you don’t use a DB transaction that you rollback ?  
Also check the statistics page in the Servoy admin pages to see if there is a delete.
