Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (5)

Resolved database rollback

  1. François Van Lerberghe
    François Van Lerberghe
  2. Valentina Database ADK
  3. Tuesday, January 12 2016, 10:55 AM
  4.  Subscribe via email
Hello,
When I open a database that it was not closed properly, the database is rolled back using the journal data.
Doing so I can lose some data last added in the database even if I've flush the database after the add of data.
How does Valentina decide what data will be rolled back ?
Can you give me more information in order to avoid the lose of data.
  1. Valentina DB ADK
  2. SOLVED!
Comment
There are no comments made yet.
Responses (5)
Ivan Smahin
Ivan Smahin Accepted Answer
Flush database really set some sort of checkpoint, so after this your changes should not be rollbacked.
But - are you sure you do the flush for database - not table? Because table.Flush does not affect rollback journal.
One more point - could you describe more detailed - how you do that flush?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Ruslan Zasukhin
Ruslan Zasukhin Accepted Answer
In case you used Table.Flush() or Field.Flush()
-- we going to claim that this methods should be marked as DEPRECATED.
they have no sense with use of journal.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
François Van Lerberghe
François Van Lerberghe Accepted Answer
Sometimes i do a database.flush, but most of the time, I do table.flush.

myVCursor.value = 'xxx'
myVCursor.UpdateRecord
myTable.Flush (if the UpdateRecord is done successfully)

Oh ! It's deprecated !
As I understand, I must replace all my table.Flush with database.Flush then ? Is that as quick as table.Flush ?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
Ivan Smahin
Ivan Smahin Accepted Answer
Exactly.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 4
Ruslan Zasukhin
Ruslan Zasukhin Accepted Answer
Exactly from Ivan - means yes replace it.

Speed already not matters because Table.Flush() have no sense with journaling.
We cannot rollback only one table, and not others.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories