Thanks Kees, Christian,
SQLSetConnectAttrW(q->hdbc, SQL_ATTR_AUTOCOMMIT,
(SQLPOINTER)SQL_AUTOCOMMIT_OFF, 0); this is what I already had and I think you
have answered the question with "The SQLite ODBC driver allows only one SQL
statement per SQLExecDirect()", this is the conclusion that I came to.
Kees, your suggestion is exactly what I did, tah is a single statement per
SQLExecDirect( ... ) SQLExecDirect("INSERT INTO t (col1,col2) VALUES
('val11','val21')");
Thanks to both of you for your quick reply, looks like I will have to accept
the way things are, but that's a small price to pay for a very useful database.
Regards
Len
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
