Subject | Search on a query |
---|---|
Author | jsbriantes |
Post date | 2003-02-21T09:06:31Z |
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?.
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.
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?.
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.