-o flag

[Joe Chasan]

On Thu, Feb 15, 2007 at 02:17:20PM -0600, Chris Rendall wrote:
> When you use the -o flag with rreport, is filePro creating a demand
> index on the record number?  When I go into Index Maintenance it shows
> an index "Built 02/15/07 on Field(s) <>". 
> 
> I'm curious on what filePro is using to create the demand index.

filepro will build the demand index containting the exact same records that
your rreport session selected.

the index sort key(s) will be the same as your report sort (on define 
output format, overridable via sort command in processing).  if no sort 
is defined, it probably defaults to the tie-breaker on matching sort 
key fields (which one would have if all had no sort!) which would be
record number.  i'm guessing the latter happened to you based on the
index comment you got.  

FWIW, I don't recall what it says if you build sort based on dummy fields 
in sort processing.  It *may* give a similar vagary.

-joe
 
--- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
-Joe Chasan-                      Magnatech Business Systems, Inc.
joe at magnatechonline.com           Hicksville, NY - USA
http://www.MagnatechOnline.com    Tel.(516) 931-4444/Fax.(516) 931-1264