Re: How to re-populate DBgrid after doing a search

From: Barak zabari (lotemlotad_at_yahoo.com)
Date: 03/17/05 

Date: Thu, 17 Mar 2005 15:43:42 +0200

it's not a good idea to work with RecNo.
The reason is that RecNo change depending on your sort order etc.
I would work with qry.Seek if you can.

"Richard Caruana" <caruanar@acay.com.au> wrote in message
news:42394E4B.86032249@acay.com.au...
> Very Good, thank you the SQL notes helped me.
>
> I was able to get grid to refresh using
>
> procedure TForm1.Button6Click(Sender: TObject);
> begin
> ADOQuery1.Close;
> ADOQuery1.Sql.Clear;
> ADOQuery1.Sql.Add ('Select * from dictionary');
> ADOQuery1.Open;
> end;
>
> I did a search (this project uses 3rd party component Rubicon2 using ADO
> bridging.) on the word "dieu" which found recno:=20795
>
> after the table refreshes how do I get it to go to recno:=20795 ?
>
> any help is appreciated
>
> Richard
>

Quantcast