Kbase P163871: Cannot change the width length on fields in the schema holder and Microsoft SQL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/15/2010 |
|
Status: Unverified
SYMPTOM(s):
Cannot change the width length on fields in the schema holder and Microsoft SQL
When trying to create a .sql file to change the width an error (.e file) such as the following is generated:
exclprog in accessmast had a change to WIDTH which was not passed to the
df file and no ALTER TABLE statement was created to change field size.
FACT(s) (Environment):
Windows
MS SQL DataServer
OpenEdge DataServer Category: SQL Server
OpenEdge 10.2x
CAUSE:
Expected behaviour, we do not support the change of the length of a field through the delta.sql utility.
FIX:
The workaround is to modify the SQL databases, and then run the update/add table definitions to update the schema holder.