Hi,

If you don't want use sproc, then use two identical queries with ordering
ASC and DESC and retrive only the first record of both. In the result you
will have the first and the last record of the original query. It is fast if
you use Maxrows = 1 and autofetchall = false.

Sandor Dobi

"Bill Morrison" <bmorrison@...> wrote in message
news:862A8B31DE3ED211A07E00805FA6307D011EE2AD@walnut...

> Afternoon Jason et al.
>
> I have an interesting problem where I need to quickly retrieve the first

and

> last record of a queries result set (just doing select min(), max() from
> blah isn't sufficient). Unfortunately, due to bandwidth constraints,

reading

> the entire table in isn't sufficient.
>
> Is there a way through the existing IBO components to accomplish this, or

is

> my need best served with a sproc of some sort?
>
> Thanks in advance,
>
>
> Bill M
>
>
>

___________________________________________________________________________

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