BlankIsNull is probably true for that column. Take a look at that item.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <mmenaz@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, July 18, 2001 1:53 AM
Subject: Re: [IBO] IBO 4.0.2c: grid and lookuplist number of displayed rows


> > I don't know what you mean by msg 8176. Please quote it in full.
> >
> msg 8176 is the number of the message I've posted here in
> http://groups.yahoo.com/group/IBObjects/, so you can go there filling
> the "msg# __ GO" at the bottom of each message form.
> Anyway, here is the message:
> >
> 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
> <