Sqlite Backup Issues

Hey guys… I am starting to get frustrated with this… can you help me out ?

The issue I am seeing here is that (without touching the code) the Async backup method in the Xojo Sqlite example does not work… then… the implementation of Async Sqlite backup in my app doesn’t work as well… Sync Backup goes fine… but Async does not work…

I am lost…
Where do I start to track this issue ?

If I set a breakpoint and get into the debugger to check the percent variable in the backupHandler.Progress method… I see “-nan(ind),”

Which I have no idea what it means…

The backup begins… but doesn’t progress… and obviously, never finishes…

nan means Not a number

https://en.wikipedia.org/wiki/NaN

ok… But why does the backup not progress ?

What is the page_size of the SQLite DB? Starting with SQLite 3.12.0, it has to be 4096 or higher in order for Backup to work.

I’ve added some information on how you can check this and change the page size on existing databases:
http://documentation.xojo.com/index.php/SQLiteDatabase.Backup

The page size IS 4096 but still can’t get the Async backup to progress…