You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
Private Declare PtrSafe Function sqlite3_backup_init Lib "SQLite3" (ByVal hDbDest As LongPtr, ByVal zDestName As LongPtr, ByVal hDbSource As LongPtr, ByVal zSourceName As LongPtr) As LongPtr
Activity
govert commentedon Jul 9, 2023
I thought I fixed it here last year. 8f233e6
Did I miss something?
KallunWillock commentedon Jul 10, 2023
I'm guessing the change wasn't made to the code in the XLSM file (Distribution Folder)?
KallunWillock commentedon Jul 12, 2023
I just checked. It looks like you updated the BAS file 4 years ago but the demonstration workbooks were last updated 7 years ago.