Subject RE: [IBO] How open a dataset with only a Bookmark record?
Author Alan McDonald
another difference is that I never select * - I always select field1, field2
etc
I don't know if that makes a difference but I think helen has mentioned many
times that select * is not a good way to go, even though some people argue
that it should be OK
Alan

-----Original Message-----
From: Marco Menardi [mailto:mmenaz@...]
Sent: Sunday, 16 March 2003 11:15 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] How open a dataset with only a Bookmark record?


I think you have made some mistake, since if you OPEN the query and
you have something like "select * from customer" you ask the database
to return ALL the records. If you then use bookmark, you are only
navigating inside that dataset and be positioned on the desired record.
Anyway, I've tried and it works as expected (by me). Use SQL monitor
to see what happens.
Of course, only some records are fetched, but I want to avoid
unecessary processing and server requests.
thanks
Marco Menardi

--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> Marco,
> Have you tried this (your) method?
> The problem I had was that it was doing exactly what you want - but
I didn't
> want it.
> If I set the bookmark directly after opening the query - I get only one
> record returned, the bookmarked record. If I open the query, then in
another
> method I set the bookmark, I get the grid buffer filled with records
which
> surround the bookmarked one.
>
> Alan
>
> -----Original Message-----
> From: Marco Menardi [mailto:mmenaz@l...]
> Sent: Sunday, 16 March 2003 10:29 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] How open a dataset with only a Bookmark record?
>
>
> I have a bookmark for a lookup dataset. I want to use that bookmark
> for opening another dataset on the same record.
> I don't want to use something like:
> with qryCustomer do
> begin
> Open;
> Bookmark := workBookmarkString;
> end;
> because this way all the data is requested to the server and THEN the
> right record is located.
> I want instead have the behaviour the IBO Search has, i.e. return only
> the desired record, but I don't know how to make my workBookmarkString
> being used as a search criteria.
> In other words, I would like to have something like:
> with qryCustomer do
> begin
> Search;
> Bookmark := workBookmarkString;
> ..First;
> end;
>
> that does not work.
> I don't want to fill the other field values for a search, since I need
> a generic solution and Bookmark produces always an unique key.
> How can I do?
> Thanks
> Marco Menardi
>
>
>
>
>
___________________________________________________________________________
> 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/



___________________________________________________________________________
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/