At 11:07 AM 03-01-01 -0700, you wrote:

>I am not sure this works with the TIBO (TDataset based) stuff. Probably the
>best way is to do it in triggers.

If BLANKISNULL doesn't work with TIBO, use a BeforePost handler to clear
it, viz.

...
if (Trim(ParamByName('MyString').AsString) = '') then
ParamByName('MyString').Clear;

Helen

>----- Original Message -----
>From: "Geoff Worboys" <geoff@...>
>To: <IBObjects@egroups.com>
>Sent: Wednesday, January 03, 2001 10:31 AM
>Subject: Re: [IBO] Treating an empty string as NULL
>
>
> > > Is there an easy way using IBO to treat an empty string
> > > as NULL when inserting or updating a record ?
> >
> > In the dataset or connection ColumnAttributes property set
> > field_name=BLANKISNULL
> >
> > HTH
> >
> > Geoff Worboys
> > Telesis Computing
> >
> >
> >
> >
>
>

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________