Carie,

My first recommendation is to call a stored procedure and let the stored procedure make all the changes. In the long run you'll get much better performance - especially if the group of updates are frequently executed.

With that said.

LOCAL hConn, lnResult
llError = .F.
hConn = SQLCONNECT(...)

*-- start a manual transaction
SQLSETPROP(hConn, "Transactions", 2)

lnResult = SQLEXEC(hConn, "UPDATE table1 ...")
lnResult = SQLEXEC(hConn, "UPDATE table2 ...")
lnResult = SQLEXEC(hConn, "UPDATE table3 ...")
lnResult = SQLEXEC(hConn, "UPDATE table4 ...")

IF (everything_is_ok)
  SQLCOMMIT(hConn)
ELSE
  SQLROLLBACK(hConn)
ENDIF

*-- You really only need to reset the transaction property if
*-- you're not going to disconnect.
SQLSETPROP(hConn, "Transactions", 1)

SQLDISCONNECT(hConn)

-Mike