SQL request result not visible or not changable

  • 10 November 2017
  • 3 replies
  • 8 views
M
Badge +10

Hi all,

I have a query action within my form that gives back a number of project numbers as dropdown.

The user can choose whatever project number he wants out of that drop down list. Everything fine.

BUT

as soon as the user opens a saved entry in order to edit it, the project number is either

- empty (sql request is executed again within edit modus -> dropdownlist with all project numbers is displayed) or

- only the already selected project number is displayed (sql request is not executed within edit modus)

What I want is that the dropdownlist is available, BUT the already selected project number is still displayed (as selected).

Is there any way to solve this? I cannot imagine that I am the first one with this problem... sad.png sad.png sad.png

Jan von Reith‌, Cosima von Kries‌

Cheers

mai-kel

3 replies

B
Badge +1

I am having this issue too. It's really frustrating as this works with Infopath but not Nintex forms.

I am hoping someone has a solution to this issue.

E
Userlevel 5
Badge +14

see these threads. it sounds to be a bug

https://community.nintex.com/thread/18021-sql-query-field-doesnt-keep-the-saved-data-in-edit-mode
https://community.nintex.com/message/71749-sql-request-control-conundrum    

C
Badge +9

It sounds to me that it has been fixed in the recent Release notes, I'm having the same issue as well, I'm going to give the upgrade a try on a 2010 env. and see if that solves it. 

Nintex Forms 2010 - Release Notes 

Nintex Forms 2013 - Release Notes 

  • Fixed an issue where the SQL Request control may not retrieves values in display mode (00177023)
  • Fixed an issue where the SQL Request control may not display the ‘Please select’ default text option (00178718; 00187508; 00185211)

Check also my question here:  

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings