-RO causes an error

Joe Chasan joe at magnatechonline.com
Fri Jun 3 11:41:27 PDT 2005


On Fri, Jun 03, 2005 at 12:38:06PM -0400, Joe Chasan wrote:
> On Fri, Jun 03, 2005 at 12:16:53PM -0400, Kenneth Brody wrote:
> > Quoting Joe Chasan (Fri, 3 Jun 2005 12:10:57 -0400):
> > [...]
> > > the workaround in my case was to add a second field to index "A" in
> > > MY_FILE_NAME, even though index was already unique, to force filepro
> > > to use new 4.5/4.8/5.0 multi-field index format internally within
> > > that index.
> > 
> > Or just don't set PFOLDIX=ON, and filePro will use the new format
> > even for single-key indexes.  (Unless there is a need to use the old
> > format for some reason.)
> 
> ken, in my case PFOLDIX wasn't set at all, so i'm not sure why index
> was in older format.  FWIW, index was on a field of 10,mdyy/ on a 
> file of 21 records.

... and since you challenged me, Ken, i have to throw it back to you as
a second bug.

it occurred to me while lunching that the filerpro file in my case was 
never around until after customer had 5.0, and i know i'd never set 
PFOLDIX in their case - so how could it get the old-style index format?  
what's the bug?  

if an index is created in ddefine/define files, a single field one (the
only kind you can build from ddefine!), it still uses the old format.

if you rebuild it in dxmaint/index maintenance, it uses the 4.5/4.8/5.0
format.

verified in both sco unix & windows
  
-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


More information about the Filepro-list mailing list