jwstl
Forms Fledgling

SQL Request Control - Not Populating

When using the SQL Request Control, I am able to successfully connect to our database, and execute the query. When in preview mode, the control is failing to populate with any values. I've tried to change the Value and Display fields to different data types, but have the same results.

Configuration:

Results in preview:

Tags (1)
0 Kudos
Reply
2 Replies
abdullahfahmi91
Cloud Wanderer

Re: SQL Request Control - Not Populating

Try using PROJECT_ID in Value field and Display field.

0 Kudos
Reply
greenawayr
Automation Master
Automation Master

Re: SQL Request Control - Not Populating

Yes, The field in your query is PROJECT_ID but in the Value field and Display field you have ProjectID. This column doesn't exist in the results returned in your query.

0 Kudos
Reply