At 07:45 AM 19/09/2003 -0600, you wrote:

>Hi,
>I have a table with a field defined as double precision which defaults
>to null, as per:
>
> -> FieldX double precision default null
>
>When I open the table containing this field, I receive an Econvert error
>saying that it cannot convert null to floating point. The error comes
>from the IB_Schema source. It only happens once, ie, if I open the table
>a second time, there is no error. I expect that it happens only when IBO
>is reading the db schema.
> If I change the field to default to 0, no Econvert error occurs.
> Am using IBO 4.2Ib, D7, Firebird 1.03, dialect 3.
> I have never seen this error with floats.
> Is this a bug in IBO? a Firebird issue? or should I not define double
>precision this way/

I suggest you do NOT set a default of null. It doesn't make sense. All
columns default to null unless told not to. If the schema is queried to
get the default values, what is Delphi going to do with null? What's
happening is that IBO is reading a "value" of null from the schema, which
causes the conversion error in Delphi. Null isn't a value.

Helen