| Subject | RE: [IBO] Locate key value AfterOpen |
|---|---|
| Author | Alan McDonald |
| Post date | 2003-01-30T00:51:50Z |
ah - thanks
I've tried viewing the monitor at other times but it appears that this fetch
intercedes in the filling of the buffer with normal records. If I wait till
the buffer is full, then do a locate, the action works as expected.
I'm not sure about resync either - maybe I'll call it afteropen but before I
do the locate
Alan
-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Thursday, 30 January 2003 11:38 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Locate key value AfterOpen
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 --
I've tried viewing the monitor at other times but it appears that this fetch
intercedes in the filling of the buffer with normal records. If I wait till
the buffer is full, then do a locate, the action works as expected.
I'm not sure about resync either - maybe I'll call it afteropen but before I
do the locate
Alan
-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Thursday, 30 January 2003 11:38 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Locate key value AfterOpen
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
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/