Re: Do not want data to auto sort



A cursor sorts data? Huh? A cursor is that little flashing thing on your
screen.

A table does not sort data per se. You can sort the data in a table while
you are viewing it. The records are stored in SOME order. I did not flat
out say they DON'T because there was a recent post where someone argued with
an MVP for most of the day claiming that tables do use a logical sort.


I said, a table should NOT be an interface.


Please do not add to a discussion if you have nothing worthwhile to add.

Thanks,

--
Rick B



<peregenem@xxxxxxxxxxxx> wrote in message
news:1123148003.668948.94770@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> Rick B wrote:
> > Tables do not reliably sort data.
>
> The word 'reliably' makes no sense here. A table cannot sort data. A
> cursor sorts data.
>
> > Tables are buckets for storing records
>
> What is it with 'buckets around here?! At the physical level, the data
> in a table is stored in a high predictable order (PK order as at last
> file compact, date/time order subsequently). You are correct in
> pointing out a table's physical attributes are not significant
> considerations. Tables should only really be considered at the
> logically level i.e. a complete set of entities.
>
> > You should not be using the tables as an
> > interface anyway
>
> Again, this makes no sense. How can table be an interface?
>


.


Loading