Hello,
Sorry for yesterday, I made a mistake in my code and consequently no
messages were displayed when encountering a constraint violation !
But now it does...
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;
Where is the error? Thanks...
Bien à vous,
Bruno WIESEN
......................................................
Bruno WIESEN [EMAIL PROTECTED]
Mac OS Software Developer
Pyramide Ingenierie sprl Tel: +32 87 292130
188 rue de Liege Fax: +32 87 292139
B-4800 Verviers Mail: [EMAIL PROTECTED]
......................................................
Le 4 oct. 07 à 14:27, Igor Tandetnik a écrit :
WIESEN Bruno <[EMAIL PROTECTED]>
wrote:
The first insert statements were made as tests, in our application we
wrap these statements in transaction...And we don't know when
something wrong happens
because commit doesn't notifie us...
... but INSERT does. Why is this not sufficient?
Is there a solution to be
notified when using commit?
Have you read anything I was saying? Have you followed the link
I've provided? I believe I've already answered this question quite
thoroughly.
Igor Tandetnik
----------------------------------------------------------------------
-------
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------
-------
