Subject | RE: [IBO] Fastest Way to locate |
---|---|
Author | Alan McDonald |
Post date | 2007-05-17T21:47:43Z |
thanks I'll take a look
Alan
Alan
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Jason Wharton
> Sent: Friday, 18 May 2007 4:24 AM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Fastest Way to locate
>
>
> Use the OrderingItems and OrderingLinks in such a way that you turn on the
> POS attribute of OrderingLinks and then you will virtualize your buffer in
> such a way that it will skip around inside the query's records based on
> internally managed parameterized queries. Do a search in the archives for
> horizontal dataset refinement and you may find more helpful information.
>
> Jason
>
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> > Behalf Of Alan McDonald
> > Sent: Wednesday, May 16, 2007 7:12 AM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] Fastest Way to locate
> >
> >
> > What's the fastest way to open a query and locate a record
> > for display in an
> > IB_Grid?
> > If I just open the query (with AutoFetchAll=False,
> > FetchWholeRows=False)
> > this seems to be the most efficient.
> > But if I then locate, of course I need to browse through a
> > lot of records to
> > find my match.
> > I'm just wondering if there is a more efficient way to
> > opening the query on
> > the initial record I need to locate and still fill the grid
> > with a minimum
> > of leading and trailing records (i.e. grid buffer only)
> >
> > regards
> > Alan McDonald
>
>
>
> __________________________________________________________________
> _________
> 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 !
>
> Yahoo! Groups Links
>
>
>
>