added to the last thing, SQLCommit will return -1 if it fails to commit the transaction then you can use AERROR() to report/log the reason for the failure if you are using manual transactions you can send multiple updates and then commit them with a single SQLCommit.

Hope that makes sense.

J