Hi,

I can't use a bookmark because the record isn't on a query before I added it.
I fetch the record ordered, but I have to use locate method to search for the
record the register I have added,
because it's a query component.

Thanks

On Fri, 21 Feb 2003 06:05:15 +0000 (UTC) helebor@... (Helen Borrie)
wrote:

> 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
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>