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)