Quoting Igor Tandetnik ([EMAIL PROTECTED]): > nbiggs wrote: > >CREATE UNIQUE INDEX IF NOT EXISTS idx_table ON table (field1, field2); > >SQL error: near "NOT": syntax error > > I've never seen such syntax. SQLite does not support it. What is it > supposed to mean anyway?
I think it's a MySQL-ism. -- Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/ "An NT server can be run by an idiot, and usually is." -- Tom Holub, a.h.b-o-i