Steffan
Level 2

I am unable to query a column that I know exists using the Lacerte SDK.

I have created a custom filter which points to column C7_190. My CTS001.IW3 file says:

"C7_190,is,1,1="

However, if I try to query this column, I get "DataSource.Error: ODBC: ERROR [42S22] [Lacerte][SQLEngine] (31750) Column not found: C7_190"

For some reason, the SDK seems unable to query a column that definitely exists.

Anyone else have a similar issue?

0 Cheers
Reply