can not set initial value of 1 character field to blank

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

can not set initial value of 1 character field to blank

Post by 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
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: can not set initial value of 1 character field to blank

Post by tford »

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
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: can not set initial value of 1 character field to blank

Post by 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
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: can not set initial value of 1 character field to blank

Post by 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
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

Post by 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?
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
aware_support
Posts: 7523
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: can not set initial value of 1 character field to blank

Post by aware_support »

You need a rule for this...
Aware IM Support Team
Post Reply