"Stephen Woodbridge" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > DROP TABLE IF EXISTS foo; > > does not seem to work via the C-API. If I type it in sqlite3 it works > fine. > > When I tried via the C-API, I got the following: > > SQL: drop table if exists addr; > > SQL error: near "exists": syntax error
My guess is, your application links against an older version of SQLite than sqlite3 utility does. "IF EXISTS" clause is a fairly new addition. Can you check the value of sqlite3_version ? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
