Subject Default value and empty string
Author mmenaz@lycosmail.com
Hi, I want to set a default value for my Descrizione field to ''
(empty string).
I have the domain
DOMAIN DESC_NUMERO_TELTYPE AS VARCHAR(30)
DEFAULT '';
and the query with GetServerDefaults to true.
But when I insert the record (I'm using a IB_Grid), if I leave the
field empty the record posted has a Null value. I've tried to put a
definition in DefaultValue property of the query with Descrizione=''
but the '' is put as field value :)
How can I do what I want (apart from entering a space in the field
when I want it to be empty). This is because in subsequent ordering,
null values have strange behaviour, while empty fields have not,
Thanks
Marco Menardi