rollback ??????

[ugg]

Can anyone tell me how to use rollback and commit etc

e.g

$rs=odbc_exec($conn, "UPDATE h set Dat = $data,
WHERE Dat = $data ");

if($rs==false){

// I want to use rollback here
}

any ideas??????

thanks

[Roger_Ramjet]

odbc_commit
odbc_rollback

[ugg]

Thanks for the code, but I have already tried the rollback and could not get it ti work. Could you please give me an examlple from the code i first posted. just assume that there are more sql commands to follow.

How do i say that if one fails then rollback must be used?

thanks alot, sorry i am new to php!!

ugg

[Sxooter]

What database are you using? Some, like older versions of MySQL, don't support it, and some, like postgresql, have a subtley different transaction syntax than oracle and what the spec says should happen.

[veridicus]

If your database supports it you can call:

odbc_exec($conn, "ROLLBACK");

Or, IIRC, for MS SQL it would be

odbc_exec($conn, "ROLLBACK TRAN");

Of course if you have implicit transactions this won't work. For MS SQL you'd first have to do a BEGIN TRAN, then either COMMIT TRAN or ROLLBACK TRAN.

If that's not the answer let us know what database you're using.

[ugg]

I am using access so if I has three update querys

$rs = (.......)

if($rs==false){

odbc_exec($conn, "ROLLBACK");

}

more querys

Would this rollback all querys which have been excuted from up to that point using theat particular connection??

What about a delete query?

THANKS ALOT

[Roger_Ramjet]

To enforce the beginning of a transaction on your ODBC connection, you can toggle the autocommit to OFF/FALSE, which commits all peding transactions on that connection before starting a new transaction

odbc_autocommit($conn,FALSE);

You then test for errors and commit or rollback as required with

odbc_commit($conn); or odbc_rollback($conn);