Subject | Fastest Way to locate |
---|---|
Author | Alan McDonald |
Post date | 2007-05-16T14:11:59Z |
What's the fastest way to open a query and locate a record for display in an
IB_Grid?
If I just open the query (with AutoFetchAll=False, FetchWholeRows=False)
this seems to be the most efficient.
But if I then locate, of course I need to browse through a lot of records to
find my match.
I'm just wondering if there is a more efficient way to opening the query on
the initial record I need to locate and still fill the grid with a minimum
of leading and trailing records (i.e. grid buffer only)
regards
Alan McDonald
[Non-text portions of this message have been removed]
IB_Grid?
If I just open the query (with AutoFetchAll=False, FetchWholeRows=False)
this seems to be the most efficient.
But if I then locate, of course I need to browse through a lot of records to
find my match.
I'm just wondering if there is a more efficient way to opening the query on
the initial record I need to locate and still fill the grid with a minimum
of leading and trailing records (i.e. grid buffer only)
regards
Alan McDonald
[Non-text portions of this message have been removed]