Updates trash database
When I make any changes in SQLPro for SQLight with a iOS Core Data SQLDatabase it seems to trash the database such that is will no longer run in my App. I have delete it and let my core data stack recreate it.
The error in the log states: "NSSQLiteErrorDomain=11" and "SQLite error code:11, database disk image is malformed'" upon launching the App after making a change inside SQLPro for SQLight
What can be done to fix this?
No after making a change to a field of type string (although any change seems to trigger this issue including setting up foreign keys) in SQLPro, closing and attempting to re-open it I receive and error message inside SQLPro too. See attached image. I have also attached the corrupt database and the shm and wal associated files.
1. Yes, the one I attached would produce the error in my initial screen shot of SQLPro
2. I did, yes. I changed a cell's value quit and re-opened SQLPro without doing anything else; including doing anything in Xcode (which was open but not running the simulator at the time.)
I just ran another test with the latest Xcode 11 beta 7 and will include the results.
Step 1 I open the file in SQLPro and edit the first record "Soda"
Step 2 I save and close SQLPro
Step 3 when I reopen the same database the records have been trashed somehow