>I want to know if an UPDATE or a DELETE worked or not using SPT. SQLEXEC() returns 1 but I don't know if the command worked or not.

Mario,

If you're using SQL Server, then I think after the update/delete you can send a "SELECT @@ROWCOUNT" to see how many records were affected by the last command. Similarly, "SELECT @@ERROR" would return the error code of the last command (zero, if it was successful).

Laterness,
Jon