Kbase P66978: Error 7520 when adding functions in the GROUP BY clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/02/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
SYMPTOM(s):
Error 7520 when adding functions in the GROUP BY clause
Column not found/specified (7520)
The GROUP BY clause contains the SUBSTRING function
Using SQL-92
CAUSE:
The GROUP BY clause can only contain column names. Functions are not allowed.
This is the form which the SQL-92 standard defines. That is, the standard defines the GROUP BY list as containing column references only.
FIX:
Remove the SUBSTRING function from the GROUP BY clause.