Question

Help with Workflow Custom Query to Microsoft SQL database

Workflow

Updated March 15, 2016

asked on March 14, 2016

Hi Everyone,

I am having issues with the Custom Query activity in Workflow using parameters. We are using Microsoft SQL Express.

When I hard code the value of the field I am querying without parameters, there is no issue and the Rows affected are displayed when testing (see attachment). Also the Query Data activity works a treat, but I will need some more advanced searches.

But when I add the Parameter to test a basic query, the following error is returned - "Incorrect syntax error near '?'.

Is there something I am missing?

cheers

Grant

Test Custom Query Syntax error with Paramaters.png

Test Custom Query Syntax working without Paramaters.png (7.84 KB)

| Download

Test Custom Query Syntax error with Paramaters.png (18.69 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on March 15, 2016

Hi Grant,

I found the issue, go to your Data Source and edit the Data Source type to ODBC with Sql. I got the same error as you since i used Sql (Direct), but this change has worked for me.

1 0

Replies

replied on March 15, 2016

Hi Darren/Gert,

Still no luck.

Darren - I did test your suggestion, it appears you need to enter the Column Name in replace of the ? symbol. Selecting the Test option, the query did not error, however it did return all records from the database, not the specified record, I used (Operations).

Gert - See my screen shots slightly modifying my query to match your suggestion, but the exact same syntax error is still produced using the Test.

cheers

Grant