Re: Do not want data to auto sort



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.
>


.



Relevant Pages

  • Re: Do not want data to auto sort
    ... What the Heck is a Cursor, ... this is not the little flashing mark that shows you where you are ... > a table should NOT be an interface. ... a query or Query object) possibly be mistaken for an 'interface' at ...
    (microsoft.public.access.tablesdbdesign)
  • Re: implementing roles in OOP......
    ... everything should be driven by abstracting the problem ... my draft interfaces define what sort of thing I would ... All I need is the Composite relationships to navigate, ... IEnumerator is an interface defined by my environment, we can put, ...
    (comp.object)
  • Re: LW9 running FIXED. hub problem found (i think)
    ... Well, this was all good news, sort of LOL ... I know its capable of some REALLY cool imagery, but why such an utterly goddam amateur interface? ... As for this part, I had to bust out laughing, as this was just too funny LOL ... I was able to start creating cool and FUN scenes pretty much right out of the shoot! ...
    (comp.graphics.apps.lightwave)
  • best option for terminal emulation?
    ... to interface a MicroVGA adaptor (http://www.dontronics-shop.com/4d- ... So I need to work out what the command protocol will be betwen the I/O ... moving the cursor to a particular location etc. ... CURSOR (Cursor addressing sequence, sends cursor to ...
    (comp.os.cpm)
  • Re: IInterfaceList and Sort
    ... Unfortunately there is no Sort method. ... {descend from this interface for specific uses ... localCompare:=.asInteger; ... TQuickSort = class(TInterfacedObject, ISorter) ...
    (borland.public.delphi.language.objectpascal)