Skip to main content
Nintex Community Menu Bar

Query Sql Control does not works

  • February 20, 2017
  • 8 replies
  • 29 views

Forum|alt.badge.img+4

Hi All,

         I am using a query sql control in my workflow to save data to an external database. I checked with the connection and execute query with some direct data. It inserts perfectly. But when i give the Item parameters or workflow parameters it does not inserts. The workflow completes successfully all the steps. Data is not getting inserted.

attached my configuration screen of query sql.

Please Help me 

Thanks

8 replies

Forum|alt.badge.img+12
  • February 20, 2017

Hello,


If you turn on error handling within the action by logging out any error, do you get anything that is going unnoticed?  


Forum|alt.badge.img+4
  • Author
  • February 22, 2017

I am getting the error Incorrect syntax near 'sql'.

insert into Requests.dbo.Req(ReqNo,Title) values ({ItemProperty:Title},{ItemProperty:Request_x0020_No})

This is my query, is there any mistake in this query?

Please help me.


Forum|alt.badge.img+14
  • Scholar
  • February 22, 2017

don't you have swapped columns? they doesn't seems to follow naming of table columns. you might hit incorrect datatypes problem.


Forum|alt.badge.img+4
  • Author
  • February 22, 2017

Yes that mistake I noticed and changed.

Now i am trying to insert only one column 

insert into Requests.dbo.Req(Title) values({ItemProperty:Title});

but here i am getting an invalid column 'Test Title' error.

'Test Title' is the Title name entered from form.


Forum|alt.badge.img+14
  • Scholar
  • February 22, 2017

I would say apostrophes are missing

insert into Requests.dbo.Req(Title) values("{ItemProperty:Title}");


Forum|alt.badge.img+4
  • Author
  • February 22, 2017

Yes. Its Missing Single Quotes not double quotes. Thanks for the clue


Forum|alt.badge.img+12
  • February 22, 2017

This is what I would've suggested, but you guys beat me to it.  Good work.


Forum|alt.badge.img+12
  • February 23, 2017

Glad you solved the issue, can you please mark the answer you found most useful in helping you solve this issue correct.