Greetings!
Perhaps I have not right ask this, as I am a newbie to SQL (about 5 years),
but, I would like to suggest that once a BEGIN is set, if there is a syntax
error after a BEGIN, that BEGIN gets deactivated. For example:
sqlite> begin;
sqlite> select foo FROM;
Error: near ";": syntax error
sqlite> begin;
Error: cannot start a transaction within a transaction
sqlite>
I know that I could rewrite the select again, but, if I am copying a string
and that string has begin; as part of the whole testing the SQL string, I
would have to type END; before I could type it back. Also, this happens if
a locked DB is encountered and the BEGIN; took, but some abnormality is
encounted and the same command is sent again. Is there a reason why the
BEGIN; stays live even though there was an error in the SQL command?
Thanks for your thoughts and guidance.
josé
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
