When using a query it brings records to the client. If you want special
capabilities you have to setup horizontal dataset refinement. With that few
of records it may be just as well you keep things as they are.

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: "Tom Deprez" <zifnabbe@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, August 19, 2002 1:30 PM
Subject: [IBO] Locate & Indexes


> Hi,
>
> I'm a little lost here. I've a TIBOQuery on a table (15795 records). The
table itself as a primary key of 'POSTCODE_ID;STREETNAME'.
> When I perform a Locate as in:
>
> qrSrvcsByStreets.Locate('POSTCODE_ID;STREETNAME',
>
VarArrayOf([tbExtInvitations.FieldByName('POSTCODE_ID').AsInteger,
>
tbExtInvitations.FieldByName('PERSON_STREETNAME').AsString]),
> [])
>
> It seems to be very slow. I've to use this query each time when I want to
insert a record in another table.
> Does TIBOQuery uses the keys defined on the table automatically (since
then locate works the fastest) or do I've to define it somewhere.
>
> Is there a better way to do this then using locate? Stored Procedure? How
would this procedure than look like?
>
>
> Thanks in advance,
> Tom.