InfoPath Dev

We are currently using a SOAP web service to submit InfoPath form data to a SQL database. The web service method that submits data generates a response so if the submission fails there is a message with details on why. We are trying to capture this response error message in our form and are wondering if one of the qrules could do ...

I'm getting results now. I looked at the SQL trace and that was valid fine so then I recreated my data connection just to be sure and voila. I can't believe how well this command works. What a find! Thank you! I appreciate your help.

 I tried that and I don't get any results for the data connection. The success box is checked though and there aren't any error messages. That must mean my formula is wrong even though the syntax verifies?  This will work on a secondary data connection, correct? And I should be able to run it locally (in an unpublished ...

 I'm currently testing out a trial version of qrules and am running into the some of same issues described in this post. I've put my concat statement into the command line formula and it verifies correctly. My statement is: concat("ModifySqlQuery /dsname=VW_DIM_INF_APPR_CURRENT /where=where DEPT = '", DEPT, ...