I have a complicated form that was built in DF 3.4.5. It worked fine until I moved the site to DF 4.1. Then the functionality of the form was broken.
Specifically, I was assembling a stored procedure call on the form in a text box using javascript, hidden by CSS, but not a hidden field. A question event later uses the stored procedure call to set the default value on a text box. The SP call looks something like this: EXEC SP_CalculateMyData 34,55,0,0,0,7,66,5 and the numbers were dependent on the choices the user made earlier on the form so my form has to assemble the stored procedure call. The javascript I use to assemble the call is working well. The problem is the question event is supposed to use the SQL that was assembled to assign a default value to a text box. It no longer enters the result of the stored procedure into the target textbox. I have read that security is tighter on DF 4.1 than it was in 4.3 or so. And that DF will no longer run a SQL script that has come from another field by means of a question event. IS That True?
Is there any way to assemble a stored procedure call that will be used on the same form later by using DF 4.1?
Thanks for your help