You are viewing limited content. For full access, please sign in.

Question

Question

Custom query column limits

asked on December 11, 2015 Show version history

Wondering if there is a limit to the number of columns that workflow can query.

I am using the following command of my external database.

The Invoice Table has 75 columns.

SELECT *Total FROM Invoice WHERE InvoiceNo = "123245'

I get error messages with this command.

If I query individual columns from the above table I get valid data, so I know the data is correct.

The Customer Table has 25 columns

SELECT *Total FROM Customer WHERE Name = "Customer1'

This runs well and returns data for all columns.

0 0

Replies

replied on December 14, 2015

What does the error message say?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.