Kbase P6718: Errors 247, 945 and 222 When Running SQL statements In The 4GL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/02/2009 |
|
Status: Verified
SYMPTOM(s):
** Unable to understand after -- "<string>". (247)
** <program> Line <number>. Invalid SQL statement. (945)
** Invalid datatype -- sample types are: char, integer, date, logical (222)
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CHANGE:
Using SQL SELECT statements in the 4GL
CAUSE:
The SELECT statement that was entered was using syntax that is only available in SQL-92
FIX:
The 4GL only supports SQL-89 syntax for SQL statements. Please refer to the SQL-89 Guide and Reference for the SQL syntax accepted by the 4GL.
If you need to use SQL-92 syntax you must access the database from an OBDC or JDBC client (like the Progress SQL Explorer).