Kbase P120694: The SQL Engine always treats a column named "ROWID" as a function
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/23/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
OpenEdge 10.0x
OpenEdge 10.1x
SYMPTOM(s):
The SQL Engine always treats a column named "ROWID" as a function
The column name is between double-quotes
The SQL Engine returns the record's ROWID instead of the actual column data
All columns are displayed with #DELETED in Microsoft Access
Microsoft Access uses the column called ROWID as the primary key
CHANGE:
Upgraded from Progress 9.1D
CAUSE:
This is a known issue being investigated by Development.
FIX:
Rename the column, for example to "ROWIDENT".