>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
Jon Rosenbaum
Devcon Drummer