Selection set problem using -rx

[Jeff Harrison]

Ray Scheel wrote: 
> 
> Jeff Harrison wrote:
> > Ok, then my next question would be, are the config files 
> and environment
> > identical on the two machines?   In particular, do you have 
> PFIXS=ON on
> one
> > and not the other?
> 
> Bingo.  On the production machine the configuration editor 
> listed PFIXS=ON
> while it was absent in test.  I turned it off in the 
> environment and am
> suddenly selecting records. 
> 
> I am scratching my head as to why that would cause problems only
> selectively.  I rebuilt all indexes earlier, though I'll 
> admit I'm a bit
> foggy on exactly what the "index scan" feature does or how it works.  
> 
> Many thanks, 
> Ray
> 
> Ray Scheel               ray.scheel at wsdtx.org 
>

No problem.  When the index scan is on filepro is looking for the field to
contain the value of "@rx".  This is a bug in my opinion.  I have also seen
similar behavior with the "=" character in that filepro does not interpret
it as a wild card as it normally would in a selection set.  As you have
found, though, at least there is a decent work-around with the eqf - You can
reverse the fields.

Jeff Harrison
jeff.harrison at epixweb.com

Author of JHExport and JHImport - The fastest and easiest ways to generate
code for filepro exports and imports.  Demos available upon request.