Hi Louis;

   A +100 return code is not an error. It just means that the SP has not returned any ANSI result set or you have reached the end of the RS during a Fetch operation. The real error (if any) would be reflected in the SQLCA.SQLDBCode and SQLCA.SQLErrText variable values.

Regards ... Chris

True, however, the email is never sent.  So something is not happening. 

Also there is not text in the SQLCA.SQLErrText variable.

Olk, so here is the "fix".

When you execute the SP in ISQL a result of 'mail queued' is returned.  In my example in PB I am not coding for any return results so SQL server returns a 100.  My code after the exec command checks for errors.  I was using the following.

IF sqlca.sqlcode <> 0 THEN
    ls_error = sqlca.sqlerrtext
    ls_error = 'Could not send the email/text message, error: ' + ls_error
    ROLLBACK;
    MessageBox ("Email/Text", ls_error, Exclamation!)
    RETURN
END IF
commit;

So when SQL server sent me back code 100 I rolled back.  But code 100 is really not a return code to rollback.  So when I changed to just this

IF sqlca.sqlcode < 0 THEN

....

End if

and then executed a commit; it worked.