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
can not set initial value of 1 character field to blank
Re: can not set initial value of 1 character field to blank
What am I missing. Why would you think that two ' would fit in a one character text attribute?
Tom - V8.8 build 3137 - MySql / PostGres
-
- Posts: 1458
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: can not set initial value of 1 character field to blank
Workaround not fix, use under bar _ if you are using this field in a query it will still suggest an empty valueBLOMASKY 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
Re: can not set initial value of 1 character field to blank
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
bruce
-
- Posts: 619
- Joined: Wed Jun 17, 2015 11:16 pm
- Location: Omaha, Nebraska
- Contact:
Re: can not set initial value of 1 character field to blank
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?
VocalDay Solutions - Agility - Predictability - Quality
We specialize in enabling business through the innovative use of technology.
AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
We specialize in enabling business through the innovative use of technology.
AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: can not set initial value of 1 character field to blank
You need a rule for this...
Aware IM Support Team