At 12:43 PM 27-02-02 +0100, Marcin wrote:

>Hellen,
>
>I put your piece of code directly to my application, but result is the same:
>vL returns all records and after closing the preview vLista remains in
>dssSearch mode. Here is my procedure:
>
> with T_qrKredyty1.Create(Self)
> do try
> vLista.CheckBrowseMode;
> with vL
> do begin
> if Active then Close;
> SQL.Clear;
> InternalDataset.AssignSQLWithSearch(vLista) ;
> Prepare;
> Open;
> end;
> Preview;
> Application.ProcessMessages;
> finally Free;
> end;
>
>Any help?

No...how frustrating. With the app I picked the sample code from, it works
exactly as I expect.
:((

Can you watch the two queries in the IB_Monitor and see what the
differences are? or try adding a Showmessage after the call to
AssignSQLWithSearch like

showmessage(vl.SQL.Text);


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com