On Sat, Nov 16, 2013:
> Stephen Chrzanowski wrote:
> > 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.
>
Maybe it should be:
TempDB.ExecSQL('PRAGMA journal_mode = OFF;');
(Note the additional semicolon in the string literal)
...as in the sample code at
http://www.itwriting.com/repos/sqlitewrapper/trunk/SQLiteTable3.pas
--
--
--
--Ô¿Ô--
K e V i N
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
