Ver:4.10.4.23731 / 6.2.7
I have a form that is set up for Initial Data Bind and it was working a few days ago just fine. Meaning when you opened the form, the initial data was in the fields.
But now the fields are empty when opening the form. I don't think I changed anything. I might be wrong, but I wasn't even working on this site in the last few days. The one difference I am sure of is that I upgraded Dynamic Forms from Ver 4.1.1 tp 4.1.4.
The initial SQL Query is not complicated:
exec LIS_SetupNewTicketDetails_GivenUserID_DataBind $(UserID)
When I run in debug mode it shows the date bind like the following: Note: I am userID = 1
SQL Debug (Parse SQL Text For Variables But ParametersOnly set to True):exec LIS_SetupNewTicketDetails_GivenUserID_DataBind 1
If I go to the SQL window and run
exec LIS_SetupNewTicketDetails_GivenUserID_DataBind 1
It correctly returns data:
1 | MyOrganizationName | Mark Buelsing | markb@domain.com | Tester@domain.com |
There is a field for each of these columns with exactly corresponding shortfieldnames.
But the initial data does not fill in to the form fields. Funny thing is that it used to work. So it used to be set up correctly.
Questions:
1. Could the problem have crept in when I upgraded to version 4.1.4?
2. What settings should I look at to problem-solve this issue?