SQL REQUEST

  • 24 April 2017
  • 1 reply
  • 5 views

Badge +4

I am trying to write to SQL table. I have a table "bJCJM" where I have columns Job (job number) and JCCo (company number). I want to validate a entry from Nintex form against Job field to show error message if Job (job number) already exists.

Here is a similar example: Nintex Forms Enterprise - SQL Request Control

sql req 2

sql req 1

#Nintex SQL Request #SQL Request


1 reply

Badge +5

Value field and Display field in SQL Request Control should follow the column name inside SQL Table.

My suggestion, what you can do to return two column from SQL Table is by having one SQL Request Control return value based on another SQL Request Control value.

Reply