setting default value

[Guest]

Hello,
I have built a procedure that set the dafult value for any field of few
table to "Null".
I did it because I would like to use SQL to populate records in the table
and this wil prevent me to give values for any fileds. This way I can pass
only values that user entered in the control.
Now I have changed my mind and would like to get rid of all that "Null" that
show up in the records, preferring blanks field.
Is there a way to programmatically set default values for fileds to Null
(Null...not "Null")?

Thanks

Nick

 

[John Spencer]

Change your procedure to set the field's default value to "" instead of
""Null"".

You will have to use an update query to get rid of any stored values that
are the string "Null"

 

[Guest]

Thanks,
but this seemss like I'm entering a ZeroLenghtString. Am I wrong?
Nick

 

[John Spencer]

No you are not wrong, but since the property is a string, this will clear
the default property, so that there is no default. If there is no default,
then null is what is stored in the field.

Make a backup of your database and try it. If I'm wrong, I will refund your
consultation fee.

 

[Guest]

You are great.

No you are not wrong, but since the property is a string, this will clear
the default property, so that there is no default. If there is no default,
then null is what is stored in the field.

Make a backup of your database and try it. If I'm wrong, I will refund your
consultation fee.