Kbase P816: Common Errors Using Visual Basic and MERANT 3.60 6
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/09/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1A
Windows NT 4.0
Merant ODBC 3.60
Microsoft Visual Basic 6 SP3
SYMPTOM(s):
SQL-92
Syntax Error (7587)
FIX:
Check your SQL statement. If the field name contains reserved characters ("), (_) or (-), enclose your field name in double quotation marks ("). For example, to display all user names and the user ID, enter this syntax into the Procedure Editor: "SELECT _userid, _user-name FROM _user ORDER BY _userid ASC In Visual Basic, you must use double quotation marks ("): "SELECT " + Chr(34) + "_userid" + Chr(34) + " FROM PUB." + Chr(34) +"_user"+Chr(34). Also, if the SELECT statement contains the WHERE clause, make sure that the data types in comparison are the same.