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
5 hours ago
- 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?