I want to ensure there is a value, but IBO does not allow the Insert to
make use of the default on the database.

Is there anyway around this problem???

Thanks,

Allen.

At 10:20 AM 11/6/2001 -0800, you wrote:

>Ihave column defined as VARCHAR(30) DEFAULT '' (CHECK VALUE IS NOT NULL).
>IBO tries to Insert a NULL for fields where the
>user did not make an entry on my entry form. That causes the check
>constraint to fail, since InterBase is not using the default.
>
>Therefore what is the best way to set the default values of an empty
>string if I am using a TIBOQuery?
>
>Thanks,
>
>Allen.