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