Kbase P128974: Delta SQL utility for DataServer for MS SQL Server converts logical data type to integer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/08/2010 |
|
Status: Verified
SYMPTOM(s):
Applying delta .df and .sql to modify schema holder and MS SQL server databases.
Fields of type logical are treated as type integer after applying changes.
OpenEdge logical data type converted to integer in both .df and .sql file.
The FOREIGN-TYPE in the .df and .sql file should be "TINYINT" instead of "INTEGER".
.df reads:
ADD FIELD <fieldName> OF <tableName> AS logical
FOREIGN-TYPE "INTEGER"
...
Changing schema holder has no effect
FACT(s) (Environment):
OpenEdge 10.x
MS SQL DataServer
Windows
CAUSE:
Bug# OE00164229
FIX:
Manually modify the .df and the .sql file created by the Generate Delta.sql OpenEdge to MSS utility from "INTEGER" to "TINYINT".