🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.apps
Article #7685

Re: Filemaker Pro stupidity

#7685
From: William Joseph Marriott
Date: Fri, 08 Mar 1991 20:26
19 lines
1226 bytes
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
Technical Details
Message-ID: <39957@cup.portal.com>
Path: arc1-ca.pugleaf.net!utzoo!news-server.csri.toronto.edu!cs.utexas.edu!usc!apple!portal!cup.portal.com!Lou
References: <92710@lll-winken.LLNL.GOV>

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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