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!
Running ODBC query with parameters
Here's the situation. I am using SSRS to construct a report using an ODBC connection to NetSuite. We have built plenty of reports this way so I know my setup is good in terms of environment, connection, etc. We are using the latest version of the Connect driver.
Let's say the query looks something like this:
SELECT C.CUSTOMER_ID, C.NAME, C.FULL_NAME FROM CUSTOMERS C WHERE C.CUSTOMER_ID = <some internal id>
The query runs fine if I provide a hard coded value for the id. The problem is when I attempt to pass the id as a parameter like so: