Path: utzoo!news-server.csri.toronto.edu!cs.utexas.edu!usc!apple!portal!cup.portal.com!Lou
From: Lou@cup.portal.com (William Joseph Marriott)
Newsgroups: comp.sys.mac.apps
Subject: Re: Filemaker Pro stupidity
Message-ID: <39957@cup.portal.com>
Date: 8 Mar 91 20:26:53 GMT
References: <92710@lll-winken.LLNL.GOV>
Organization: The Portal System (TM)
Lines: 19

macq@miguel.llnl.gov (Don MacQueen) writes:

> The latest on my list of things Claris broke when they went from
> Filemaker II to Filemaker Pro:
>
> A database is sorted.  You find a subset of the records.  The found
> subset is NOT, I repeat NOT NOT NOT sorted in the original order.

FileMaker has *never* retained the sorted order of records after a Find.
This is largely because FileMaker (all versions) is disk-based. When
you perform a sort, the "ID Numbers" of the records are re-arranged,
not the actual records. Thus, FileMaker uses the sorted "ID Number"
list when displaying records. This is because re-arranging the actual
records on your disk would take a long time. When you do a Find, the
list of record ID numbers changes, and thus another sort is required
to put them in order again.

-Bill Marriott
 lou@cup.portal.com