There are a few different ways to accomplish this.
The way I most recommend would be to use input parameters instead of trying
to locate. This way you are just fetching the record(s) of interest only.

To get emulation of smart buffering you can try two options.

#1: Set FetchWholeRows to false. (vertical dataset partitioning)
#2: Use POS attribute of OrderingLinks property (horizontal dataset
partitioning)

For more information on each of these please refer to documentation and
archives.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: <antoni.aloy@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, November 26, 2002 2:50 AM
Subject: [IBO] Locate problems


Hi!

I'm trying to use locate to go to a record but it's terrybly slow as it
tries to fecth all the records (its a 10.000 records table and the
connection is a ISDN 128K).

I have the table mapped to a IB_Query (QTickets) indexed on the fields I'm
searching on (serie, numero).

QTickets.Locate('SERIE,NUMERO',VarArrayOf([serie,numero]),[])

What could be happenning? Is there a more efficient way to do that?

============================================
Antoni Aloy López
IT MyTravel Incoming Services Spain
Tel. +034 971221097
Fax. +034 971288295
Member of MyTravel Group
============================================