Question

Workflow to query SQLBase database

Workflow Version 9 Version 10 Business Processes

Updated April 11, 2017

asked on April 10, 2017

I have a user who runs a macro in excel to run a query against my SQLBase server. I am trying to have workflow run the query on a schedule instead, not sure yet what I will do exactly with the output, but that comes later.

I've been mostly working with the Query Data tool, but I also have tried the Custom Query, which I think is ultimately what I need to use for my query as it's pretty complex.

If I test the connection through the data source manager it reports everything is fine, I see all the proper tables in the drop down when using Query Data, however it seems like no matter what query I try to run I always get 0 rows. The same queries work fine in other tools.

0 0

Replies

replied on April 10, 2017

Is it a simple SELECT query? Are we talking about running it through the Test Query link or are you running the workflow.

0 0

replied on April 10, 2017

yeah, Just a SELECT command, and yes, the Test Query link.

0 0

replied on April 10, 2017 • Show version history

Post a screen shot of the test Query screen and we may be able to spot any problems with syntax.

Also, if you are running x64 Workflow, do you have an x64 SQLBase ODBC driver?

0 0

replied on April 11, 2017

Yes, x64 on both. And I use the same driver in excel and it works just fine.

0 0

replied on April 10, 2017

Here is a test query I've been playing with to just try and get something.

0 0

replied on April 11, 2017

Isaac, I have had similar issues when the database table data has spaces either side of the value. There are some left or right trim commands you can use if this is the case?

Jonathan

0 0

You are not allowed to follow up in this post.

Question

Question

Workflow to query SQLBase database

Replies

Sign in to reply to this post.