Kbase P141464: The default value is not being populated on the existing records on the MS SQL Server Database when
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/07/2009 |
|
Status: Verified
SYMPTOM(s):
The default value is not being populated on the existing records on the MS SQL Server Database when a new nullable field is added through delta SQL utility
FACT(s) (Environment):
The nullable field is newly added to the existing table on the MS SQL Server database
Only the new records are being populated with the default value on the new nullable fields
The already existing fields are left empty for the new nullable field with the default value
Windows
OpenEdge 10.x
CAUSE:
Bug# OE00175772
FIX:
Upgrade to OE10.1C03 and 10.2A01
if upgrade is not possible, run UPDATE statement on SQL Server to update the columns; or edit the .sql generated and add 'WITH VALUES' to the nullable column definition with a default in the ALTER TABLE statement before running the .sql on the MS SQL Server Database.