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!
ODBC OpenQuery Date issue
All,
We were just upgraded to 2018.1 this morning and now all of our queries that include a date in the where clause error.
Example. We have a C# program that uses the ODBC OpenQuery to get some data out of NetSuite. Here is the query
select * from OPENQUERY(NETSUITE_PRODUCTION, '
--select sum(item_count) as item_count
select date_last_modified
from Administrator.transactions trans
inner join Administrator.transaction_lines tln on tln.transaction_id = trans.transaction_id
inner join Administrator.LOCATIONS loc on loc.location_id = tln.location_id
where transaction_type = ''Item Receipt''
and loc.name = ''Warehouse''