Welcome back! Ask questions, get answers, and join our large community of tax professionals.
- Topics
- Training
- Community
- Product Help
- Industry Discussions
- User Groups
- Discover
- Resources
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Intuit Accountants Community
- :
- User Groups
- :
- Lacerte SDK Group
- :
- Issue Querying DATA7 in 2023 Lacerte/Individual Module
Issue Querying DATA7 in 2023 Lacerte/Individual Module
Options
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
Steffan
Level 2
11-22-2024
11:15 AM
- Mark as New
- Permalink
- Report Inappropriate Content
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?
1 Comment 1
kamprich
Level 1
Friday
- Mark as New
- Permalink
- Report Inappropriate Content
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