> I import a Spreadshhet 'into' a tiboquery.
>
> If I have the TIBOQuery with cached updates = true ( to increase
> performance ) but I also want to check as I insert each record there
> is not already a duplicate key - what can I use besides the Locate
> function ?
>
> If the cached updates = true does the Locate do a fetchall or will it
> just look at the cached records ?
>
> The table I insert records to is always cleared before each import,
> so the locate really only has to look at the current transaction.
>
> I don't want the locate to do any unnecessary actions as performance
> is critical.

Locate will first operate on cached records and then it will also do a
specific query on the server to see if a record that matches is there. IF
the server doesn't have a matching record no fetches will be performed. If
there is a matching record is there it will fetch until it comes into the
dataset.

Jason Wharton
CPS - Computer Programming Solutions
Mesa Arizona
http://www.ibobjects.com

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