At 10:06 AM 21/02/2003 +0100, you wrote:

>Hi, I need to find a record in the result of a SQL instruction in a query
>component, that is, I execute the query and then I have to move to a
>particular record. If I use locate method, It find well, but It's to slow.
>Because It's a query I can't use key method (like in tables). What can I do?.

Have you thought of using bookmarks?

>The situation is:
>- A client runs a search, that I implemented with a query, to fetch some
>records on a DBGrid.
>- Then, when he see the records, he add another record.
>- When he finish, I run the query again to select the records he has added
>and
>the records he searched before add. This is fast.
>- And then, and here is the problem, I like to move the DBGrid to select the
>record he has added, between all records that he searched. Thanks.

The only way you will be able to achieve this is if the required rows can
be ordered (via SQL) by some means that returns the set in the order you
want. All ordered sets in SQL boil down to an ORDER BY clause...

Helen