SCOUG-Programming Mailing List Archives

Date:	Sat, 25 Mar 2006 22:41:45 PST8
From:	Sheridan George <s-geo@usa.net >
Reply-To:	scoug-programming@scoug.com
To:	scoug-programming@scoug.com
Subject:	SCOUG-Programming: Data Repository/Directory

Content Type: text/plain

Gregory W. Smith wrote:
> "Lynn H. Maxson" wrote:

> Ordered???? I thought we were talking about a database here.
>>From what I remember from dbExpert, databases are UNORDERED
> collections of data. When you select on a column entry, you
> get all of the rows that match the column. But there is no
> order to the rows that are returned. (This is similar to
> retreiving the keys from a Python dictionary. The keys are
> returned in an unordered list that has no relation to the
> order in which the entries were put into the dictionary.)
>
>
In the databases I've used the retrieved rows are unordered unless the retrieval is via an index.
Then the rows are in index order unless a specific other order is commanded in the query. In fact,
one database I used extensively, Knowledgeman, always presented the query response in index order
if an index had been made for that table whether or not an index was cited in the query. Sometimes
that was not what I wanted but I got it in index order anyhow.

Sheridan

=====================================================

To unsubscribe from this list, send an email message
to "steward@scoug.com". In the body of the message,
put the command "unsubscribe scoug-programming".

For problems, contact the list owner at
"postmaster@scoug.com".

=====================================================

Return to [ 25 | March | 2006 ]

SCOUG, Warp Expo West, and Warpfest are trademarks of the Southern California OS/2 User Group. OS/2, Workplace Shell, and IBM are registered trademarks of International Business Machines Corporation. All other trademarks remain the property of their respective owners.