What version are you using? The "IF NOT EXISTS" clause only exists in SQLite 3.3.0 and later.
- Pam On 4/5/06, Lucky Luke <[EMAIL PROTECTED]> wrote: > > Ok, a VERY VERY strange error, which I can't solve. > > I use the SQLite.NET wrapper from www.phpguru.org to use it with C#. > > I have the following query: > > sql = "CREATE TABLE IF NOT EXISTS bot_users (" + > "username VARCHAR(100)," + > "password VARCHAR(100) " + > ")"; > > But when I try to execute this I get the following error: > > Sqlite.NET.SQLiteEception: near "NOT": syntax error > > There isn't something wrong in my query I thought.. > Greetings, > > LuckyLuke > >