[sqlite] Correct way for INSERT OR REPLACE and COMMIT

[Cecil Westerhof]

I have the following Tcl code:
    set rollback "
    INSERT OR REPLACE INTO pipRollback
    (pipType, package, old, new)
    VALUES
    (:pip, :package, :old, :new)"

    db eval {BEGIN TRANSACTION}
    foreach verbose ${packagesVerbose} {
        .
        .
        .
        if {${doAppend}} {
            append packages "${package} "
            db eval ${rollback}
        }
    }
    db eval {COMMIT TRANSACTION}

I suppose it is the correct way, but is there something I should change?

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