S
SteveJ
According to MS's SQL documentation, the following applies:
Column definition No entry, No
entry, Enter a null value
no DEFAULT definition
DEFAULT definition
Allows null values NULL
Default value NULL
Disallows null values Error
Default value Error
I have a nvarchar column for which I have set a default value of '' i.e.
zero length string.
New records are not problem, changed ones are:
If data is entered this is stored OK. The problem occurs when the record is
revisited and the user decides to remove all the data. When the column data
is committed, the error "Non-nullable column cannot be updated to Null"
occurs.
According to MS's description above, I would expect the default value to be
entered i.e. zero length string.
Anyone got any words of wisdom on this?
Column definition No entry, No
entry, Enter a null value
no DEFAULT definition
DEFAULT definition
Allows null values NULL
Default value NULL
Disallows null values Error
Default value Error
I have a nvarchar column for which I have set a default value of '' i.e.
zero length string.
New records are not problem, changed ones are:
If data is entered this is stored OK. The problem occurs when the record is
revisited and the user decides to remove all the data. When the column data
is committed, the error "Non-nullable column cannot be updated to Null"
occurs.
According to MS's description above, I would expect the default value to be
entered i.e. zero length string.
Anyone got any words of wisdom on this?