InfoPath Dev

My Dear.. I am already implementing that exact scenario. Rethought my process. I believe I have it nailed on this front. Working on the SSIS package now. Thanks again!

I tried to separate my code above from my actual comments. But none of the options for formatting are available and it's removing my hard returns, tabs and spaces.

DECLARE @emps AS TABLE (evc_code varchar(max)) INSERT INTO @emps (evc_code) SELECT DISTINCT evc_code FROM prj_detail WHERE (fiscal_year = @year) AND (evc_type_code = 'E') AND (rev_type_code = '01') DECLARE @names AS TABLE (emp_code varchar(max), emp_name varchar(max)) INSERT ...

Works with the Main connection as well. And if you still want the command, just out of curiosity, Let me know. I think I still have your email.

That did the trick my dear! Once again you're a life saver. Hope you're having a good start to the new year.

7.2 is my current version. I have the group Exec Hist on my form. Tells me everything is successful. (Successful checkbox checked) No errors. I'll try the implicit transactions command. Do I need to turn it back on after? Or is it only for the one transaction that it's off?

Unfortunately that's proving difficult. Client hasn't given me access. :( Any other way of perhaps finding out what's happening behind the curtain? I know I can run a packet capture, but I'm not sure I'd get the response I'm actually looking for.

I did attempt a secondary connection. I set it up to receive though and got the same results. Do I need to set it up to submit instead?

concat("ExecuteSqlQuery /dsname=Main connection /sql=UPDATE test_table SET goal_pct = '", goal_pct, "' WHERE emp_code = '", emp_code, "'") Above is my command I'm executing when the user clicks the button. Though everything in InfoPath says its "successful", nothing actually is ...

Found our problem!!! nothing to do with form. Found our main UDC was pointing at the wrong DB. Bypassing our target DB. Thank you for help. Thought id update you on what we found.