Subject RE: [IBO] How to clear IB_Query parameters?
Author dennis@aceware.com
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