[sqlite] Help with IF NOT EXiSTS

[nbiggs]

I get the following error if I try to use the IF NOT EXISTS function.
If I take out the "IF NOT EXISTS", the statement creates the index.
The same happens when I try using IF NOT EXISTS in a CREATE table
statement.
 
CREATE UNIQUE INDEX IF NOT EXISTS idx_table ON table (field1, field2);
SQL error: near "NOT": syntax error
 
Any ideas?  Thanks for your help.
 
Nathan Biggs