This select statement is not the actual fetch intended to deliver records.
It is purely a part of the Locate operation to see if there is a record that
can be brought into the buffers. There is some other reason that records are
not being pulled into the buffer.

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: "Lester Caine" <lester@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, January 29, 2003 12:39 AM
Subject: Re: [IBO] Locate key value AfterOpen


> > query is opened, I can see the query statement as
> > SELECT FIELD1
> > , FIELD2
> > , ETC
> > WHERE PRIMARYKEY=?
> > where ?value is the bookmark.
>
> If that is the FIRST open, then that is the problem.
> I open the query without a 'filter' before doing any
> 'Locate' work. It will only fetch records as it needs them,
> but obviously it needs to fetch a set of files around the
> locate to display them.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services