Subject RE: [IBO] How to clear IB_Query parameters?
Author Claudio Valderrama C.
Clear deletes all parameter information from the Items property of the
TParams object.
Params[i].Clear only clears the value of the parameter, it doesn't wipe out
this or all parameters. I understand the param is set to NULL.
Different things. I'm not sure what the original asker wanted to do.

C.

> -----Original Message-----
> From: Hie Joen, Lie [mailto:hiejoen@...]
> Sent: Viernes 23 de Febrero de 2001 13:39
>
> Maybe Params.Clear as in BDE ?
>
> HJ
>
> Jason Wharton wrote:
>
> > Yes, I think the person was actually trying to ask something
> else with this
> > one.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> > ----- Original Message -----
> > From: <dennis@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Wednesday, February 21, 2001 10:09 PM
> > Subject: RE: [IBO] How to clear IB_Query parameters?
> >
> > > At 02:01 AM 02/22/2001 -0400, you wrote:
> > >
> > > > > -----Original Message-----
> > > > > I have a IB_Query connected to a IB_Grid which I want to
> refresh so
> > > > > that it reflects changes in the table. The SQL query is
> simply 'SELECT
> > > > > * FROM tablename;'. How can I refresh these paramaters?
> > >
> > > >Loop from zero to Params.ColumnCount -1
> > > >and call the Clear method of each parameter
> > >
> > >
> > > Out of true ignorance, I ask: Why would you ever "clear"
> parameters? If
> > > you're going to refresh the display with updated values, why
> would you not
> > > just:
> > >
> > > [disable controls, etc....]
> > >
> > > with queryGridQuery do begin
> > > Params[0].AsString := 'someString';
> > > Params[1].AsInteger := 'someInt';
> > > Open;
> > > end;
> > >
> > > Doesn't assigning new values to the Params in effect clear them?
> > >
> > >
> > > Dennis McFall
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>