I open an embedded database in my app in Xojo Debugger and if it crashes or I stop the debugger (no clean shutdown) then it will crash on any subsequent VDatabase.Open in either the Debugger or the compiled app If I call VDatabase.CheckRollback() it returns True. This is occurring even though I have not modified any data or modified any schema in the database. I do have an open readonly VCursor on a single table as a client cursor and no locks when the app is initially exited.
I can open in in Valentina Studio, and when I agree to rollback the database it opens and I can then open it in my application.
Is there anyway to prevent this sequence of events? Is there way to programmatically rollback the database? I flush the DB after modifications. How should I handle this after deployment? Any Ideas?
This is for Xojo Version 2019 Release 3.1 and Valentina V4RB version 10.1.1 on MacOS 10.14.6. Target is x86-64.