Trying again should no longer drop the tables you created or reload the case.
This is also true with switching between cases, with one big caveat: this only affects cases that have been loaded after this update. This means that if you played the first case before this update and now are on the second case, your tables for the second case will be preserved but not the tables for the first case if you switch back to it. However, if you played the first case after this update, you should be able to switch to it without losing progress.
In other words, your current progress should not be affected but your progress before this update has not been saved. All cases loaded after this update should have their progress preserved.
This update is a pretty big change, so please let me know if there are any issues.
Update Notes:
Gameplay Changes
Retrying cases no longer erases created tables
NOTE: This only affects cases you have played after this update
Any case currently loaded will have their tables saved
Any cases loaded before this update will not have their tables saved.
For the 7th case (wiki level):
xCalibur32 now mentions selling passwords in his player profile
Misc Changes
Make game's executable icon consistent on all platforms
Batch inserts when loading tables
Hopefully prevents some crashes on Mac
Bug Fixes
Fix formatting in credit tables
For the 9th case:
Fix time column in *_price tables being a TEXT type instead of INT