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
>
>
