[sqlite] What happens when a call contains two SQL statement

[Cecil Westerhof]

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)
        VALUES
        (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
independent.

-- 
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users