can not set initial value of 1 character field to blank

BLOMASKY

To eliminate Nulls, I wanted to add an initial value of '' for a string field with a length of 1. Aware complains that the 2 quote symbols are 2 many characters. I know I can do this in a rule, but that seems silly. Anyone know an easy way to fix this?

Thanks
Bruce

tford

What am I missing. Why would you think that two ' would fit in a one character text attribute?

PointsWell

BLOMASKY wrote
To eliminate Nulls, I wanted to add an initial value of '' for a string field with a length of 1. Aware complains that the 2 quote symbols are 2 many characters. I know I can do this in a rule, but that seems silly. Anyone know an easy way to fix this?

Thanks
Bruce

Workaround not fix, use under bar _ if you are using this field in a query it will still suggest an empty value

BLOMASKY

IF I dont have a default value then SQL adds the field as a NULL. I want to eliminate nulls in this attribute. I want all new records to be created with an empty string ''. I do not want a _ in the field.

bruce

johntalbott

It sounds like you'd prefer to do this from AIM, but how about setting a default value for the column to '' in SQL Server?

aware_support

You need a rule for this...