Kbase P162764: SQL: Error (10713) executing a CREATE VIEW statement.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/03/2010 |
|
Status: Unverified
SYMPTOM(s):
SQL: Error (10713) executing a CREATE VIEW statement.
Error: Syntax error in SQL statement at or about "2Characters" ) AS SELECT Customer." (10713)
The above error is generated executing the following CREATE VIEW statement:
CREATE VIEW "yshanshi"."vCustomer"
(
"AColumnNameWhoseLengthIsMoreThan32Characters"
)
AS SELECT
Customer.Custnum
FROM
PUB."Customer"
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
The length of the column name identifier is more than the maximum 32 characters allowed length for an SQL identifier.
FIX:
Ensure that the none of the names of the VIEW columns exceed 32 characters.