|Subject||Re: [IBO] Retrieving First/Last record from a query.|
> If you don't want use sproc, then use two identical queries with orderingif
> 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
> you use Maxrows = 1 and autofetchall = false.Just use TIBOTable for that and call First and Last then.
Be sure to have supporting indexes.
IBO figures out all the rest for you.
CPS - Mesa AZ