Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : I get a Syntax Error message or Lexical Element error and can't find the problem?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC SQL Sample Scripts Forum

 New Topic 
 
 Post Reply 
 I get a Syntax Error message or Lexical Element error and can't find the problem? 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-02-25 21:14:01

Look at your SQL statement and check for the following:

  • Values to be compared or placed in a file must be surrounded by single quotes (') unless they are numeric, then they should not.
  • Table and Field names should be surrounded by double quotes (") when they are reserved words.
  • Check our list of supported functions in the manual to verify that the SQL statement complies with the drivers currently supported operators and functions.

For example:-

select * from account

works without a problem, but if you do:

select desc from account

you will receive the following error:



This is because desc is the reserved word for descend. To fix this simply run:

select "desc" from account

 

 

  Top 
 New Topic 
 
 Post Reply 

Jump to