Kbase P149317: When do we create initial value "?" in schema holder for MS SQL server?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/9/2009 |
|
Status: Unverified
GOAL:
When do we create initial value "?" in schema holder for MS SQL server?
GOAL:
When a character field will have initial value "?" in schema holder against MS SQL server?
FACT(s) (Environment):
Windows
Progress 9.x
OpenEdge 10.x
FIX:
When a varchar field in MS SQL server has default value "?", it will be pulled in as having initial value "?" in schema holder. For example,
CREATE TABLE [dbo].[customer](
[custnum] [int] NULL,
[country] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[name] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[address] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[address2] [varchar](35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[city] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[state] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[postalcode] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contact] [varchar](30) ourier New" color=#0000ff size=2>COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[phone] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[salesrep] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creditlimit] [decimal](9, 2) NULL,
[balance] [decimal](9, 2) NULL,
[terms] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[discount] [int] NULL,
[comments] [varchar](80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fax] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[emailaddress] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PROGRESS_RECID] [bigint] NULL,
[PROGRESS_RECID_IDENT_] [bigint] ourier New" color=#0000ff size=2>IDENTITY(1,1) NOT NULL,
[test] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_customer_mei] DEFAULT ('?')
) ON [PRIMARY]
Field "test" is pulled in as
ADD FIELD "test" OF "Customer" AS character
FORMAT "x(50)"
INITIAL ?
POSITION 14
LENGTH 50
ORDER 220
FOREIGN-POS 21
FOREIGN-NAME "test"
FOREIGN-TYPE "VARCHAR"
DSRVR-PRECISION 50
DSRVR-SCALE 0
DSRVR-LENGTH 50
DSRVR-FLDMISC 0
FIELD-MISC22 "Y"
QUOTED-NAME """test"""
MISC-PROPERTIES "".