Kbase P6512: Error 7579 when creating SQL-92 View
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/31/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Error 7579 when creating SQL-92 View
View column list must be specified as expressions are given (7579)
using LEFT function in the select statement
can't create SQL-92 View
CAUSE:
Missing column in the View
FIX:
Specify Field's name in the View :
example : create view theView (fld) as (select left(fld,2) from pub.table)
Note : The field name in the view does not have to be the exact field name as the one used in the left function.