I didn't think of the Refresh, many many thanks Harald

-----Oorspronkelijk bericht-----
Van: Harald Klomann [mailto:nibler@...]
Verzonden: donderdag 29 maart 2001 11:19
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: AGAIN - [IBO] Search question



Nico Callewaert wrote:

>
> If I would remove the InvalidateSQL, the statement will not reprepare

again.

> To set the SQLWhereItems in the OnClick event of a checkbox won't work
> because, the only place you can have SQLWhereItems defined is in the
> OnPrepare clause of the query. So when a user clicks the checkbox, I

need

> to Reprepare the statement, so the correct SQLWhereItems is set in the
> OnPrepare event.
>

Ok, I see what you want do !

in the OnClick event of the checkbox :

procedure TForm1.CheckBox1Click(Sender: TObject);
begin
IB_Query1.InvalidateSQL;
IB_Query1.Refresh
end;


Then it will work !

Harald

Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]