Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

PROGRESS SQL 92 ODBC driver " Syntax error (7587) "

« Go Back

Information

 
Article Number000002176
Environment
Question/Problem Description
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution

About: PROGRESS SQL 92 ODBC driver " Syntax error (7587) "

Check your SQL statement. If your field name contains a reserved characters ("), (_) or (-), you have to enclose your field name in double quotation marks (").

For instance, you want to display all user name and user ID. In the Procedure Editor you will use the following syntax:" SELECT _userid, _user-name FROM _user ORDER BY _userid ASC

In Visual Basic, you have actually to use double quotation marks ("): "SELECT " + Chr(34) + "_userid" + Chr(34) + " FROM PUB." + Chr(34) + "_user" + Chr(34)

Workaround
Notes
Attachment 
Last Modified Date9/14/2015 6:25 AM