Skip to main content

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:


 


9438i7F1B006686C98BCE.png


9440i651C591E4B61A6AA.png


 


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


 


 


 

Hi


 



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).  


 



This is not how the control works.  Only the SQL Request control is populated with the query results.


 


Reply