Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Query using orderLine table works in SuiteQL but not in ODBC query
Hello! I'm running into an issue with a ODBC query I'm trying to write for the Netsuite v2 data source that involves the orderLine table.
When I run the query in SuiteQL it works just fine and returns the expected results. However when I run the query through ODBC I get the error: "[NetSuite][ODBC 64bit driver][OpenAccess SDK SQL Engine]Syntax Error in the SQL statement.[10104]".
If I remove the orderLine selects and joins from my ODBC query the rest of it works fine.
I remember reading that ODBC queries have some nuances to them and some syntax and commands are different or just don't work. I'm starting to wonder if this is one of those instances?