Locate and AfterScroll

[Eric ten Westenend]

Hi

I'm opening a dataset with 100 records.
In the AfterOpen i try to locate a certain record,

It looks like a scan is done through the table because a afterscroll event
is called for every record found before the record i'm searching for is
found.

I did not expect this.

Using IBX 11,11 on Ib2007

Eric

[Craig Stuntz [TeamB]]

Post by Eric ten Westenend
I did not expect this.

Expectations are easy to fix. :)

[Bill Todd [TeamB]]

Post by Eric ten Westenend
I did not expect this.

How else can you locate a record in a query result set? Reading the
records sequentially is the only way. If you do not want to iterate
through the records and have AfterScroll fire you need to put the
locate criteria in the WHERE clause of a SELECT and let the server do
the searching.

[Robin Martain]

Post by Eric ten Westenend
I'm opening a dataset with 100 records.
In the AfterOpen i try to locate a certain record,
It looks like a scan is done through the table because a afterscroll
event is called for every record found before the record i'm
searching for is found.

Hi Eric,

As has been mentioned, this is exactly the eay searches on result sets
are done, by design (and logical necessity).

How come you are returning a result set and then searching for a record
after that? This is normally something you would do in the WHERE or
HAVING clause and thus only return the result set which matches your
parameters.

Maybe you could tell us what exactly you are trying to do?