Is there a way to call a SQL command by using a Javascript (On button click)

  • 21 May 2017
  • 1 reply
  • 2 views

Badge +4

Is there a way to call a SQL command (SP)  by using a Javascript (On button click), and return the values or result on same Nintex form, while keeping the form opened/ not submitted.

in a way like below, needs the get details/ call a SQL SP or web service and return the results on the below fields.

Is this possible with Nintex forms? without depending on Nintex workflow.

203278_pastedImage_2.png


1 reply

Badge +11

Hi,

assuming you are using IE this should give you start: How to connect to SQL Server database from JavaScript in the browser? - Stack Overflow 

BUT as mentioned on StackOverflow: Sending SQL queries directly from JavaScript is a security issue and therefore I recommend some other approach.

I haven't used Nintex Forms in a while but isn't there a "SQL Query" control?

Regards

Philipp

Reply