sqlite3.Open(db)
#ifdef _DEBUG
    sqlite3.SetTrace();		//logging queries
#endif

// initialize transaction
BEGIN TRAN;
// transaction
INSERT INTO sales
VALUES ('7896', 'JR3435', 'Oct 28 1997', 25, 'Net 60', 'BU7832');

BEGIN TRY
    BEGIN TRANSACTION 
        exec( @sqlHeader)
    COMMIT
END TRY
BEGIN CATCH
    IF @@TRANCOUNT > 0
        ROLLBACK
END CATCH