Qdabra qRules

Re: ExecuteSQLQuery Successful but nothing happens in DB

Mfranco — Mon, 18 Jan 2016 20:36:33 GMT

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.

Re: ExecuteSQLQuery Successful but nothing happens in DB

Hilary Stoupa — Mon, 18 Jan 2016 20:28:46 GMT

Hey, that is awesome news, now we both learned something new today. :)

Re: ExecuteSQLQuery Successful but nothing happens in DB

Mfranco — Mon, 18 Jan 2016 20:25:37 GMT

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

Re: ExecuteSQLQuery Successful but nothing happens in DB

Hilary Stoupa — Mon, 18 Jan 2016 20:22:18 GMT

I should have been more clear. I'd like to see the command text from the execution history, after the concat statement has been applied. :)

Per MSDN, implicit_transactions is per connection: https://msdn.microsoft.com/en-us/library/ms187807.aspx

Re: ExecuteSQLQuery Successful but nothing happens in DB

Mfranco — Mon, 18 Jan 2016 20:12:34 GMT

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?

Re: ExecuteSQLQuery Successful but nothing happens in DB

Hilary Stoupa — Mon, 18 Jan 2016 20:08:00 GMT

Blech. :) Okay - not sure what version of qRules you are running - if you check the QdabraRules data source, is there a group called ExecutionHistory? If so, can you drag that onto your form and test the command so you can see the actual command being used? I know with stored procedures and InfoPath we have (or at least at one time had to) set implicit_transactions off - maybe start your update statement with that? Worth a try....

Re: ExecuteSQLQuery Successful but nothing happens in DB

Mfranco — Mon, 18 Jan 2016 19:59:27 GMT

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.

Re: ExecuteSQLQuery Successful but nothing happens in DB

Hilary Stoupa — Mon, 18 Jan 2016 19:50:28 GMT

Nope, should be a receive connection... are you able to run a SQL trace and see what is happening?

Re: ExecuteSQLQuery Successful but nothing happens in DB

Mfranco — Mon, 18 Jan 2016 19:45:24 GMT

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?

Re: ExecuteSQLQuery Successful but nothing happens in DB

Hilary Stoupa — Mon, 18 Jan 2016 19:36:44 GMT

I'm not sure offhand if this was tested with a main db connection with submit enabled - can you try with a secondary SQL DB Connection? You may also want to run a trace on your server so you can see what's happening there.

ExecuteSQLQuery Successful but nothing happens in DB

Mfranco — Mon, 18 Jan 2016 19:20:52 GMT

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 updated. As stated I'm not getting any errors. The Main connection is a simple SELECT emp_code, goal_pct FROM test_table. Submit enabled. Filler form 2010, Full trust with a Cert from the CA. Any ideas on why it's not updating the record?