Delphi Firemonkey MacOS App Store Sandboxed apps

[MikeD]

Delphi Firemonkey (XE8) MacOS App Store Sandboxed apps have limited access to locations for file access. Files (databases) stored outside the sandboxed area (like in Documents or Desktop) can only be accessed via a file open or save dialog. Any other files (like temp files and journal files) must use the same filename with a different extension.

Is there any way other than turning off journaling that I can control what the database temp file is named?

When I browse to create (save dialog) a database, the file is created but as soon as I try to add a table I get an error because of permissions. All of the code works fine for the non-app store version of the app.

[MaximG]

Unfortunately, the described behavior fully depends on implementation of SQLite itself : https://www.sqlite.org/tempfiles.html (Section “2.4. Master Journal Files”) and we cannot affect it