Subject Re: [IBO] Proper usage of AssignSQLWithSearch
Author Helen Borrie (TeamIBO)
At 12:43 PM 27-02-02 +0100, Marcin wrote:
>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? 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


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