Level 4

Issue Querying DATA7 in 2023 Lacerte/Individual Module

Forum|Forum|1 year ago
November 22, 2024
2 replies
33 views

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?

K

kamprich

Level 3

I have the same problem with the Series 1 table. The easiest way to debug is to use the Excel ODBC interface and dump the table of a client. Then you can see the actual codes and series for the query since Intuit doesn't document any of the tables. You can get more info about the ODBC Excel connection in SDK documentation.

Regards,

Rick Kamp, EA

SteffanAuthor

Level 4

Hi Rick,

You might find these files useful: "C:\Lacerte\24tax\2024.3.5.0\ind\usdbdef.i24" "C:\Lacerte\24tax\2024.3.5.0\fid\usdbdef.f24" (etc)

There is one for each module and they define most of the columns. It is no help for Table 7, though, as that table is different from the others and isn't fixed for everyone. It's confusing to me, maybe Robert can explain if he sees this thread. 😛

Best,

Steffan

SteffanAuthor

Level 4

Unfortunately, this seems to be broken for another year. 😕😕 Querying 2024 Lacerte for a column that definitely exists, C7_191 results in "Column not found: C7_191". Meanwhile, that custom filter works just fine in 2024 Lacerte.