Kbase P141751: SQL: Error (7587) Executing an SQL query in a Visual Basic ODBC client application
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/02/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL: Error (7587) Executing an SQL query in a Visual Basic ODBC client application
Syntax error (7587)
FACT(s) (Environment):
The same SQL query executes without error in the Progress SQL Explorer Tool JDBC Client
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Syntax error: The SQL statement had a semicolon character ";" at its end. This is permissible in the Progress SQL Explorer Tool JDBC client but not in Visual Basic ODBC client application.
FIX:
Correct the SQL statement syntax error by removing the semicolon from the end of the SQL statement.