Re: Do not want data to auto sort


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.

.

Relevant Pages

  • Re: Do not want data to auto sort
    ... Thanks for the terribly interesting information on the term "cursor". ... As far as the interface comment, if you will read the previous posts, you ... > sort the data in a table while you are viewing it" sounds. ... > a query or Query object) possibly be mistaken for an 'interface' at ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Dual Boot Fedora Core 3 & Windows
    ... On the initial screen you see, is the cursor ... flashing next to the 'title' of your default O.S.? ... 'time-out' to launch your default O.S., or you can use the directional keys ... > partition strictly for fedora. ...
    (Fedora)
  • Re: Cant Unlock Computer
    ... "FranCR9" wrote in message ... My computer is locked and I can't unlock it. ... The box to enter my password is there and the cursor is flashing, ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Focus to SubForm Control
    ... the SubForm, the cursor is not visible. ... form after viewing the results from the immediate window, ... IS flashing as it does when I use page down. ... cboDirectory, there appears to be no way to prove this without going ...
    (microsoft.public.access.forms)
  • FOLLOWUP: Who is changing my #$@# mouse cursor??
    ... The custom control window that was flashing did not have keyboard focus. ... how much the cursor flickers seems to depend on the message load. ...
    (microsoft.public.vc.mfc)
Loading