🚀 go-pugleaf

Thanks,

Problem solved.

Curt

"Lock Horsburgh" <lock@lhorsburgh.NO.RUBBISH.freeserve.co.uk> wrote in
message news:3af29986_1@dnews...
>
> "Curtis Reimer" <curtisr@lvcontrol.mb.ca> wrote in message
> news:3af02729_2@dnews...
> > Hello,
> >
> > When posting records to the database, I get the following error when we
> try
> > to put an empty string into a field.
> >
> > Field 'tblLocation.Description' cannot be a zero-length string
> >
> > The interesting portion of the code is essentially
> >
> > tblLocation->Edit();
> > tblLocationDescription->AsString = description;
> > tblLocation->Post();
> >
> > where
> > - tblLocationDescription is a TWideStringField
> > - description is an empty AnsiString
> >
> > Why can't a string be set to zero-length?  The field is not part of the
> key,
> > required, etc.  Does it have something to do with variants being used
> within
> > the code?
> >
> > Details you might like to know:
> >
> > OS : WinNT SP6a
> > MDAC: V2.6
> > C++ Builder V5 Professional, Update Pack 1
> > ADO Express, including update
> > DB: Access 2000
> >
> > Thank You,
> >
> > Curt
> >
> >
> >
>
> Is there a NOT NULL    constraint on that column?
>
> Lock.
>
>