WIESEN Bruno <[EMAIL PROTECTED]>
wrote:
I have another problem, I would like to create an unique index that
rollbacks on conflict...I've read in the book "The definitive guide
to SQLite" that
it was possible by specifying a conflict clause. What I did but I
have an error when creating the index !
CREATE UNIQUE INDEX AccountNumber ON Account (number ASC) ON
CONFLICT ROLLBACK;
For some reason, the syntax of CREATE INDEX statement doesn't allow one
to specify conflict resolution clause:
http://sqlite.org/lang_createindex.html
You'll have to do it in CREATE TABLE, as I've shown in my first
response.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------