[QODBC-Online] Troubleshooting - Select statement is not working
Posted by Jack - QODBC Support on 11 January 2016 10:14 AM
Troubleshooting - Select statement is not working
I am evaluating the product. When I did this SQL Statement:
ListID column data type is varchar, So you need to add quotes (i.e. ') around it. Please use below query & try again.
select * from Customer where ID='557'
ID is not part of QODBC-Online Schema, Please use ListID.
You can get QODBC Online table schema from below link:
Tags: QuickBooks Online, QBO, QODBC Online, Customer