Knowledgebase
[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

Problem Description:

I am evaluating the product. When I did this SQL Statement:

select * from Customer where ListId=557

I was getting a column not found the error. The QBO online documentation says the Customer table has a field called "Id" but this as well comes back as "column not found".

Can you let me know if this unique ID column is being renamed or something?

Solution:

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 ListId='557'

Regarding ID, I think you might have tried

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:

Please refer QODBC Online Data Layout for more details:

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).