Kbase P137143: ALTER TABLE table_name ADD COLUMN column_name text(integer) returns Inconsistent types (7481) error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/11/2008 |
|
Status: Unverified
SYMPTOM(s):
Altering a table using "text(20)" as column attribute causes inconsistent types error
ALTER TABLE table_name ADD COLUMN column_name text(integer)
ALTER TABLE qvr ADD COLUMN u_16695_100001 text(20)
Inconsistent types (7481)
FACT(s) (Environment):
OpenEdge 10.1C
All Supported Operating Systems
CAUSE:
Expected behavior as "text" is not a valid expression for the column definition in the ALTER TABLE statement.
FIX:
The correct syntax is :
ALTER TABLE table_name ADD COLUMN column_name CHAR(integer)
Working example:
ALTER TABLE qvr ADD COLUMN u_16695_100001 CHAR(20);