🚀 go-pugleaf

What is the ADOQuery1->Parameters->Items[0]->Bound property ? don't see it
anywhere !


"Rick Golden" <GoldenRick@hotmail.com> a �crit dans le message news:
3c0690b7_1@dnews...
> 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
> > >
> > >
> >
> >
>
>