Skip to main content
Nintex Community Menu Bar
Solved

SQL Request problem - SQL query goes over some tables (join) and references at another control.


Forum|alt.badge.img+4

Dear Community,

 

I like to use the control "SQL Request". So far it works...  However when I save the form and open it again I get following message (see attachment: Attention required.jpg).

The message: "Attention Required. Please note: This value has been updated outside of the form."

196814_pastedImage_5.png

This only appears in control where the SQL query references at another control and where many tables are concerned (inner join).

SELECT distinct DEPARTMENT.ID, DEPARTMENT.Name
 FROM [BlaserAppSupport].[dbo].[HR_ORG_CODESYSTEM], [BlaserAppSupport].[dbo].DEPARTMENT, [BlaserAppSupport].[dbo].COMPANY
 where COMPANY.ID = HR_ORG_CODESYSTEM.COMPANY_ID
 and DEPARTMENT.ID = HR_ORG_CODESYSTEM.DEPARTMENT_ID
and Company.ID = Company

 

The value and the id are connected to the correct fields. Everything works like it should. Only the form does not take the values.

 

Does somebody know this problem (bug)? If yes I would greatly appreciate any help or inputs.

 

Thanks in advance.

Andy

Best answer by labasmuse

Everything works when the control name and the colum name (text connected to...) are different!!!

I used the same name for the control and for the text column and that caused the problem.

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img+4
  • Author
  • 22 replies
  • December 9, 2016

Now I found out that the control in the sql query is  not the problem. The problem results because of joining some tables.


Forum|alt.badge.img+4
  • Author
  • 22 replies
  • Answer
  • December 9, 2016

Everything works when the control name and the colum name (text connected to...) are different!!!

I used the same name for the control and for the text column and that caused the problem.


  • Novice
  • 1 reply
  • December 18, 2019

I am having the same issue, I have tried rename the control name, change the value fieldname, rename text connected to name, nothing work. I then set the ID connected to field name, and it works.



  • Novice
  • 2 replies
  • November 2, 2022

@hing1129 This works for me. Thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings