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.


[Non-text portions of this message have been removed]