Allen,

I usually use 'n/a', 'not entered' or something similar as my default value or
text strings. There are a number of pitfalls on relying on NULL, both
theoretical and actual.

I dont know whether IBO allows you to use DEFAULT values, but it should

hth

Ed

"G. Allen Casteran" 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.
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/