On Dec 05, 2006, at 5:27 PM, Tom Benson wrote:
Or you can
UPDATE
COMMIT
SELECT
UPDATE
COMMIT
- Tom
The only problem with that is commit is very "global" in nature and
if what you really need is a nested transaction this won't work
ie/
if you need to do something where one commit is nested inside another
rs = sqlselect
while rs.eof <> true
rs.edit
insert/update record in a different table
commit this insert/update
make changes to rs record
rs.movenext
wend
commit all changes to rs
you cannot do this without using a new connection or some other work
around since SQLite does not support nested transactions (they are
not alone in this)
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
