Open KallunWillock opened 1 year ago
I thought I fixed it here last year. https://github.com/govert/SQLiteForExcel/commit/8f233e6350d2b2714f8a391a695b79b3446b9dfe Did I miss something?
I'm guessing the change wasn't made to the code in the XLSM file (Distribution Folder)?
I just checked. It looks like you updated the BAS file 4 years ago but the demonstration workbooks were last updated 7 years ago.
I just tried running the demo routine, and it crashed Excel four out of four times. I stepped through the code, and it crashes on the operative line of the SQLite3BackupStep routine.
I believe this is a result of the sqlite3_backup_init API declaration, which appears to return a Long data type, which is then passed to the BackupStep routine as the backuphandle (LongPtr). I changed the sqlite3_backup_init API declaration to return a LongPtr instead (as below) and it no longer crashes.