> Is there a way to find out the position of a record in a Local
> Interbase database?  How?  What I really want to do is display
> something like "Record xx of yy" where xx is the current record and yy
> is the total number of records in a dataset.

> Kenny

> >Is there a way to find out the position of a record in a Local
> >Interbase database?  How?  What I really want to do is display
> >something like "Record xx of yy" where xx is the current record and yy
> >is the total number of records in a dataset.

> You can get YY from the RecordCount property of the dataset.  You might
> note though that there have been reports of bugs in this property, so
> others simply count the number of rows in the dataset by brute force
> (looping through the set).  You can manually maintain the value of XX by
> going to the top of the set (First) and setting XX to 1.  From then on,
> manually update its value as you traverse through the dataset.  Not quite
> nice huh?  

> IMHO, SQL tables were not designed for traversing row by row, as are
> local tables.  That's why there is no easy way of getting the physical row
> position.  Even Delphi recognizes that.  Have you seen how the elevator in
> the vertical scrollbar of a DBGrid takes only 3 positions: top, middle and
> bottom?  That's because those are the only row positions it knows of a
> dataset: top bottom and somewhere in between.

> Lito Dizon
> adi...@us.net