Indexing Question

Jean-Pierre A. Radley appl at jpr.com
Tue Oct 19 09:09:44 PDT 2004


Courtney propounded (on Tue, Oct 19, 2004 at 11:04:47AM -0400):
| I know this has been answered and recently...but I lost my notes...
| 
| I need set up a "reverse" index...with most current date first...how can I
| do this?

The simplest solution is to run the latest version  of filePro, which
lets you build descending automatic indices.

Next simplest is to build a demand index on the date, descending.

To make an automatic index on older versions of fP, you need to add
another real field to your map and fill it with dz - at td, where dz
is the highest date according to your PFCMARK, i.e. if PCMARK=80, then
the new field would contain 12/31/79 less the current date.  It's quite
impractical for searching, though, because no one would readily be
able to do that calcaulation for searching purposes.

-- 
JP


More information about the Filepro-list mailing list