Subject RE: [IBO] Locate key value AfterOpen
Author Alan McDonald
If I put
IB_Query1.Bookmark := qbmBlock;
in the IB_Query1 AfterOpen event (after storing the bookmark ro qbmBlock
and I have put the call in the BeforePrepare event, then when the
query is opened, I can see the query statement as
where ?value is the bookmark.
Now when the form comes up, the grid is populated with only one row, the
bookmarked row.
Of course, an SQL statement like this is only going to bring back one record
but I am confused as to how setting the bookmark causes WHERE clause to be
inserted. I thought that setting a bookmark would do a seek on the already
opened query.

How do I set it up, such that the bookmark assignment does not confine the
query to one record?


-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Wednesday, 29 January 2003 8:38 AM
Subject: Re: [IBO] Locate key value AfterOpen

Not sure why there would only be one record.
Seems more details are needed.

Jason Wharton
CPS - Mesa AZ

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

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <>
Sent: Monday, January 27, 2003 10:30 PM
Subject: [IBO] Locate key value AfterOpen

> I've been trying to get my methodology correct for this for quite some
> time - I seem to have come up against a brick wall.
> I've got an IB_ dataset working well in a IB_ grid. I can sort etc fine.
> I want to "locate" my users on the last record (keyvalue) they were on
> exiting the application) each time they start the application again.
> I'm using the POS=0 syntax in the OrderingLinks.
> Without the POS=0 clause and using the
> IB_Query1.KeyFields.Values['BNO'] := irLastBlock; // registry integer
> IB_Query1.LookupKeyForFields;
> I locate the record in question without trouble but it seems (is) slow to
> get there.
> With the POS=0 clause, it is faster but the grid is left with only one
> record in it ( the record in question) and no apparent way to get all
> records visible (loaded).
> Does anyone have an idea as to what I'm missing?
> thanks
> Alan

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to