Kbase P131885: Logical fields are displayed as Y/N after MSS migration when they were displayed as True/False in Pr
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/8/2008 |
|
Status: Verified
SYMPTOM(s):
Logical fields are displayed as Y
FACT(s) (Environment):
Windows
OpenEdge 10.x
MS SQL DataServer
Same logical fields are displayed as True/False in progress application
database migrated to MSS SQL using migration utility
CAUSE:
Originally this was the DF for the logical field in question.
ADD FIELD "CancelType" OF "JobSalesHist" AS logical
FORMAT "Contract/Option"
INITIAL "Contract"
LABEL "Cancel Type"
SQL-WIDTH 1
COLUMN-LABEL "Cancel!Type"
Once the database was converted to SQL database using Data Administration -> Data Server -> MS SQL Server Utilities -> Schema MigrationTools the field did not have a default value in the SQL database (0 or 1).
FIX:
Changed the initial value to "true" in Progress database and once convert again, the default value will be set and the logical fields will display as True / False