"Mark Riehl" <[EMAIL PROTECTED]> wrote: >> > For testing, I've modified the the insert to look like this: > char *insertStatement = "PRAGMA synchronous=OFF;BEGIN;INSERT INTO > sampleTable VALUES (\"hostname\", \"6\", \"5.1.0\", \"0\", \"1708\", > \"1196303669.065335988998\", > \"hostIfc=eth0:1;hostIp=172.16.1.1;msgCount=0;queueSize=0 (0 > peak);\");COMMIT;"; > > Is this the correct syntax for the PRAGMA statement? Can I issue it > once and will it remain active as long as the connection is open? >
The PRAGMA syntax is correct. Issue it once when you initially open the connection. The BEGIN and COMMIT are automatic and can be omitted (for additional speed). SQL wants values to be quoted using single-quotes, not double-quotes. SQLite allows double-quotes but it is technically wrong. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
