cancel
Showing results for 
Search instead for 
Did you mean: 
lgiambar
Nintex Newbie

SQL Request Control populating on run now but not on actual form

Jump to solution

When using the SQL Request Control, I am able to successfully connect to our database, and execute the query. When in preview mode, or after publishing the form, the control is failing to populate with any values.

Any advice??

0 Kudos
Reply
14 Replies
emha
Nintex Newbie

Re: SQL Request Control populating on run now but not on actual form

Jump to solution

I think 'Value field' and Display field' fields should refer to columns returned by SQL.

so either put there directly SQL column name (EmployeeNum) or populate Staff_ID reference with string 'EmployeeNum'

0 Kudos
Reply
Stonehage
Nintex Newbie

Re: SQL Request Control populating on run now but not on actual form

Jump to solution

Also try this. Under advanced make sure control mode is set to Edit.

0 Kudos
Reply
lgiambar
Nintex Newbie

Re: SQL Request Control populating on run now but not on actual form

Jump to solution

Unfortunately this did not help

0 Kudos
Reply
lgiambar
Nintex Newbie

Re: SQL Request Control populating on run now but not on actual form

Jump to solution

Unfortunately this did not help

0 Kudos
Reply
sojanm
Nintex Newbie

Re: SQL Request Control populating on run now but not on actual form

Jump to solution

So how did you make the new sql statement, is it like

SELECT EmployeeNum AS Staff_ID FROM VW_viewname 

Or you can try giving EmployeeNum as Display and value field

0 Kudos
Reply
emha
Nintex Newbie

Re: SQL Request Control populating on run now but not on actual form

Jump to solution

can you post a screenshot what you have exactly tried?

0 Kudos
Reply
lgiambar
Nintex Newbie

Re: SQL Request Control populating on run now but not on actual form

Jump to solution

I will post them below

0 Kudos
Reply
lgiambar
Nintex Newbie

Re: SQL Request Control populating on run now but not on actual form

Jump to solution

I made the Value and Display fields both EmployeeNum, displays on run now, but not on form:

 Then I changed the control mode to Edit, but got the exact same results 

0 Kudos
Reply
emha
Nintex Newbie

Re: SQL Request Control populating on run now but not on actual form

Jump to solution

could you try to rewrite your statement as follows:

select EmployeeNum as EID, EmployeeNum as EVal from ....

and set

'Value field' to EID

'Display field' to EVal

Reply