SCOUG-Programming Mailing List Archives

>> Next Message >>

Date:	Sun, 26 Mar 2006 09:20:51 PST8
From:	"Gregory W. Smith" <gsmith@well.com >
Reply-To:	scoug-programming@scoug.com
To:	scoug-programming@scoug.com
Subject:	SCOUG-Programming: Data Repository/Directory

Content Type: text/plain

Sheridan George wrote:>
> 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

As I read the description, only one talbe had an index. Then
again, I might be wrong. In fact, I know I am wrong since I
could only find two noun phrases to map to four columns in one
of the tables.
--
Gregory W. Smith (WD9GAY) gsmith@well.com

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

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