Pascal Data Objects

procedure TPDO.commit;

Commits a transaction, returning the database connection to autocommit mode until the next call to TPDO.beginTransaction starts a new transaction.

    db.beginTransaction;
    db.execute_now(
            'UPDATE league_setup ' + 
            'SET baseline_flags = 127 ' + 
            'WHERE season = 2003');
    db.execute_now(
            'DELETE FROM seasonal_configuration ' +
            'WHERE season = 2003 and config_name LIKE ''stage%''');
    db.commit;