Kbase P96664: SQL-92: Is referencing an alias of a calculated field supported in an ORDER BY clause with OE10?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/2004 |
|
Status: Unverified
GOAL:
Is referencing an alias of a calculated field supported in an ORDER BY clause with OE10?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
Yes, OpenEdge 10.x supports this feature.
The following example illustrates this feature:
SELECT Region + Statename AS MyCol
FROM pub.state
ORDER BY MyCol
Note that prior OpenEdge 10.x, running the above example returns the error 7520 as expected and explained in the solution P96664