Re: Do not want data to auto sort
- From: "Rick B" <Anonymous>
- Date: Thu, 4 Aug 2005 10:05:15 -0500
Again, is this adding anything useful to the conversation? Your little
semantics are interesting, but don't really add anything to the topic.
Thanks for the terribly interesting information on the term "cursor". I'm
sure we'll all benefit from reading this.
As far as the interface comment, if you will read the previous posts, you
will find that many newer users work directly in the tables. They add data,
view data, sort, delete, etc. They do not take advantage of the objects
designed for this purpose. They use the table as a user interface to the
database. An interface is the screen used to allow a user to communicate
with the computer. In most cases, this would be a form, but many newer
users mistakenly use the tables.
Have a good day,
--
Rick B
<peregenem@xxxxxxxxxxxx> wrote in message
news:1123166439.726374.89730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> Rick B wrote:
> You seem to be having problems following things.
>
> > A cursor is that little flashing thing on your screen.
>
> I suppose this was meant to be ironic? The MSDN article
>
> What the Heck is a Cursor, Anyway?
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbegvb/html/whatheckiscursoranyway.asp
>
> opens with these lines
>
> "No, this is not the little flashing mark that shows you where you are
> on the screen. You can think of a cursor .... as another way of
> referring to a recordset."
>
> > A cursor sorts data? Huh?
>
> Allow me to quote further:
>
> "when our application issues the SQL query, the results are really
> returned in no specific order. The records returned reflect the
> arbitrary order in which they exist in the database - usually the order
> that they were entered in. However, they are presented to us in a nice,
> sequential order. This is what a cursor does for us - it manages the
> recordset."
>
> I hope you can now appreciate now absurd a statement such as, "You can
> sort the data in a table while you are viewing it" sounds.
>
> > there was a recent post where someone argued with
> > an MVP for most of the day claiming that tables do use a logical sort.
>
> At the *physical* level a table has a predictable order. At the
> 'logical level a table has no inherent order. So you totally missed the
> point.
>
> > You should not be using the tables as an interface
> >
> > a table should NOT be an interface.
>
> Change 'should not' to 'cannot'. How could a *database* table (likewise
> a query or Query object) possibly be mistaken for an 'interface' at
> all?! If this is meant to be humour (do you mean 'table' as in a piece
> of furniture, perhaps?), then sorry but it is totally lost on me.
>
> Please do not add to a discussion if you lack even a basic grasp of the
> fundamental concepts.
>
.
- Follow-Ups:
- Re: Do not want data to auto sort
- From: peregenem
- Re: Do not want data to auto sort
- References:
- Do not want data to auto sort
- From: Rod
- Re: Do not want data to auto sort
- From: Rick B
- Re: Do not want data to auto sort
- From: peregenem
- Re: Do not want data to auto sort
- From: Rick B
- Re: Do not want data to auto sort
- From: peregenem
- Do not want data to auto sort
- Prev by Date: Re: UPDATE and ALTER in transactions do not mix
- Next by Date: Relationship Diagram
- Previous by thread: Re: Do not want data to auto sort
- Next by thread: Re: Do not want data to auto sort
- Index(es):
Relevant Pages
|