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 made 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 also 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 the 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 the QODBC-Online Schema. Please use the listed.

You can get QODBC Online table schema from below link:

Please refer to QODBC Online Data Layout for more details:

 

 

Tags: QuickBooks Online, QBO, QODBC Online, Customer



(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).