Kbase 20288: SQL-89: Error: (965) selecting records having double underscores characters in one or more of thei
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/07/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 7.x
Progress 8.x
MERANT ODBC (SQL-89) driver
SYMPTOM(s):
Error:[MERANT][ODBC] PROGRESS driver][PROGRESS]** Column <name> not found in table <name>. (965)
Selecting records having double underscores characters in one or more of their column names like 'Customer.Gross__Income'. Notice the double underscores characters between the words 'Gross' and 'Income' in the 'Customer.Gross__Income' filed name.
CAUSE:
The Progress ODBC driver uses double underscore characters to reference array column elements. For example it uses 'Month__3' to reference the 3rd element of the Month array column.
FIX:
Use the special character '\' to escape the double underscore characters. For example, if the table Customer has a field with a name containing two underscores characters like 'Gross__Income' then the correct syntax would be:
SELECT Gross\_\_Income FROM Customer.