--- In IBObjects@yahoogroups.com, James <james_027@t...> wrote:

> I really need the no of record to be seen easily. Iam dealing about

1 to

> 20 records, if the record is above less than 5 it can be easily

counted

> but it is more than, I think it is much better to display the no of
> record for the comfortability of the user. Hi Jason how do we uses

the

> count of records in the buffer? or the endrownumber or

lastrownumber

> suggested by Beyers.
>
> By the way this idea just came out of my mind. Does the ib_grid can
> display the number of records or should I say records position

number?

> Just like the microsoft excel where is the most left column we

could see

> the numbers?
>
> Thanks everyone for replying.

James,

The big problem here is that you are missing the point that SQL does
not have a record number. The sooner you get your users awayfrom any
dependency upon record numbers and counts in lists, the better we all
will be.

Granted your example indicated a small number of records in this
case. What happens when the count goes up a few hundred or a few
thousand, or....??

Using the real data as a visual reference is the best model.

The last thing you want is a user saying "I was editing record 4
when...." Um which record is that?? In xBase that was the norm. No
longer so with SQL.

Have you ever heard of Joe Celko? His SQL books are a real must read.
Great explanations.

Allen.