Skip to main content
Nintex Community Menu Bar

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

  • May 21, 2017
  • 1 reply
  • 11 views

Forum|alt.badge.img+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

Forum|alt.badge.img+11
  • Nintex Partner
  • May 23, 2017

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