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
- [sqlite] Help with IF NOT EXiSTS nbiggs
- [sqlite] Re: Help with IF NOT EXiSTS Igor Tandetnik
- Re: [sqlite] Re: Help with IF NOT EXiSTS Paul Tomblin
- RE: [sqlite] Re: Help with IF NOT EXiSTS nbiggs
- Re: [sqlite] Help with IF NOT EXiSTS drh