🚀 go-pugleaf

this should work

ADOQuery1->Parameters->Items[0]->Clear();
ADOQuery1->Parameters->Items[0]->Bound = true;



Jakob Petersen <Jakob@microhouse.dk> wrote in message
news:3c065e0c$1_2@dnews...
> Hi,
>
> The Clear() method on the parameter wont work with strings.
> Use
>
>  ADOQuery1->Parameters->Items[0]->Value = System::Null
>
> Instead which is the ONLY (XP) solution on ADO parameter clearing
problems.
>
> Best Regards,
>
> Jakob Petersen
> Microhouse
>
> "mafi" <mafi@multimania.com> skrev i en meddelelse
news:3c0281a0_1@dnews...
> > Hi !
> > I'm using a TADOQuery to insert data into a table with the Parameters
from
> > another table.
> > When I execute the query, if I got a NULL field I got a EOleException
that
> > says "Parameter object is improperly defined. Inconsistent or incomplete
> > information was provided"
> >
> > My code's like this:
> > ADOQuery1->Parameters->Items[0]->Value =
> > ADOQuery2->FieldByName("field1")->AsString;
> > ...
> >
> > this : ADOQuery1->Parameters->Items[0]->Value = NULL;
> > doesn't work as well, and the paNullable option of the Attributes
property
> > doesn't change anything.
> >
> > How can I insert data with NULL value ?
> >
> > Thanks
> >
> >
>
>