Subject | Re: [IBO] record count |
---|---|
Author | allencasteran |
Post date | 2004-02-10T05:44:42Z |
--- In IBObjects@yahoogroups.com, James <james_027@t...> wrote:
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.
> I really need the no of record to be seen easily. Iam dealing about1 to
> 20 records, if the record is above less than 5 it can be easilycounted
> but it is more than, I think it is much better to display the no ofthe
> record for the comfortability of the user. Hi Jason how do we uses
> count of records in the buffer? or the endrownumber orlastrownumber
> suggested by Beyers.number?
>
> 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
> Just like the microsoft excel where is the most left column wecould see
> the numbers?James,
>
> Thanks everyone for replying.
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.