Subject | Locating |
---|---|
Author | Scronkey |
Post date | 2002-08-07T03:12:24Z |
Hi there,
Coming from a BDE background, I think I'm still having some
conceptual issues.
I have a table with 2000 records.
When I do a T_IBQuery.Locate, locating the last record in the table,
it seems to take some time, as it "Fetches" all records.
A dialog pops up with,
"Fetching Query Results"
(taking around 8 secs)
until the last record is reached.
What am I not understanding? Do I close the query, make the WHERE
clause reflect the record I want then re-open it?
I guess I just don't understand why all records are fetched when
doing a locate.
btw, I am doing a locate on the PK.
Rgds,
-Ryan
Coming from a BDE background, I think I'm still having some
conceptual issues.
I have a table with 2000 records.
When I do a T_IBQuery.Locate, locating the last record in the table,
it seems to take some time, as it "Fetches" all records.
A dialog pops up with,
"Fetching Query Results"
(taking around 8 secs)
until the last record is reached.
What am I not understanding? Do I close the query, make the WHERE
clause reflect the record I want then re-open it?
I guess I just don't understand why all records are fetched when
doing a locate.
btw, I am doing a locate on the PK.
Rgds,
-Ryan