My form is an admin approved form, when I test the form with InfoPath preview the ModifySQLQuery runs fine. When I publish the form and try to test in the browser the ModifySQLQuery command does not appear to be running. The command is set to run via rules on when a field is changed. I am not getting an error message.
The command is: concat("ModifySqlQuery /dsname=GetRoutes /where=where Facility='", ., "' Order by Facility,InternalRunNbr"). and is set to run when Facility changes.
Any ideas or suggestion as to why this would be occurring?
Any assistance is appreciated.
Thank you