I am working with Tcl. The best is of-course a general answer, but if it is
depending on the used language I will be satisfied with the Tcl answer. ;-)

Say I have the following code:
    set SQLCmd "
        DELETE FROM testing
        WHERE  key = 12
        INSERT INTO testing
        (key, value)
        (12, 'Just some text')
    db eval ${sqlCmd}

If the insert goes wrong, will the delete be rolled back, or not?

I could use INSERT OR REPLACE, but the above code would be database

Cecil Westerhof
sqlite-users mailing list

Reply via email to