Subject | Default value and empty string |
---|---|
Author | mmenaz@lycosmail.com |
Post date | 2001-07-02T17:52:56Z |
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
(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