Sometimes datastores get into a weird state and need manual attention, such as SQLite datastores opened dynamically with OpenDataStore that lock the database file. In this case, it may be necessary to close the datastore manually. Could add a "Close Datastore" menu item somewhere in the application menus.
Environment
TSTool version (e.g., 14.0.1)
Steps to reproduce
Use NewSQLiteDatabase. Run the command but don't use CloseDataStore.
Expected Behavior
Database should be unlocked and closed.
Actual Behavior
File appears to be locked. Subsequent SQL inserts add to the database, resulting in too many records.
Subject of the issue
Sometimes datastores get into a weird state and need manual attention, such as SQLite datastores opened dynamically with
OpenDataStorethat lock the database file. In this case, it may be necessary to close the datastore manually. Could add a "Close Datastore" menu item somewhere in the application menus.Environment
Steps to reproduce
Use
NewSQLiteDatabase. Run the command but don't useCloseDataStore.Expected Behavior
Database should be unlocked and closed.
Actual Behavior
File appears to be locked. Subsequent SQL inserts add to the database, resulting in too many records.