Hello Community,
I am working in SharePoint 2013 and I am trying to configure the SQL Request control. A little background about what I have done so far:
- Created a table with a column called "IBU_Descr" and populated column with data
- Created a form field "Item ID", Single Line Textbox
- Created a form field "IBU Number Test", SQL Request
Next, I configured the IBU Number Test field as shown below:
Finally, I have tested the query using the SQL Request control's built in test function and it works, returning the expected fields.
So the problem is this, once I save, publish and run the form, the Item ID field (Single Line Textbox) is not populated with the query results of the IBU Number Test (SQL Request).
Has anyone else seen this problem? Do you know how to fix it? If so, please provide guidance and examples.
Thanks!
Tom