I'm not sure why this code is breaking:
procedure SaveDatabaseTo(fName:string);
var
TempDB:tsqlitedatabase;
begin
TempDB:=TSQLiteDatabase.Create(fName);
TempDB.ExecSQL('PRAGMA journal_mode = OFF');
db.Backup(TempDB);
tempdb.free;
end;
It fails at the PRAGMA statement. In the CLI, the command works on an
empty database, however setting this to anything causes a fault. I checked
with SQLite Expert and I can execute the call with the same DLL I'm using
in my application. I'm using a later version of 3.07 of the amalgamation.
The code I'm using is from here:
http://www.itwriting.com/blog/?page_id=659
Anyone have any ideas?
fName is never :memory: as this procedure is called from a Windows Save
dialogue.
This isn't a huge deal for me. I would just prefer not seeing the journal
file show up on my desktop, however, for future reference, inquiring minds
would like to know. :]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
