"Dual criteria indexes" (was Re: What should fp 6.0 look like?)

[Cole, Ken (ABRC)]

I can replicate this with just two S1 fields and two S2 fields in the
table.  Bill Randall and I have discussed it in a number of e-mails
dating back to November 2003 when I proved it was a problem in 5.0.??
Which was the latest version then, and I did promise him some sample
data and map files but a work around for me made it low priority.

Ken

> -----Original Message-----
> From: Howie [mailto:howiewz at beonthenet.com] 
> Sent: Saturday, 23 October 2004 6:37 AM
> To: Kenneth Brody; tom heine
> Cc: filepro-list at lists.celestial.com
> Subject: Re: "Dual criteria indexes" (was Re: What should fp 
> 6.0 look like?)
> 
> From: "Kenneth Brody" <kenbrody at bestweb.net>
> To: "tom heine" <tch at aljex.com>
> Cc: <filepro-list at lists.celestial.com>
> Sent: Friday, October 22, 2004 1:37 PM
> Subject: "Dual criteria indexes" (was Re: What should fp 6.0 
> look like?)
> 
> 
> | tom heine wrote:
> | [...]
> | > associated fields working in dual criteria index's
> | [...]
> |
> | What is a "dual criteria index", and what "doesn't work" with them 
> | with associated fields?
> |
> 
> 
> It hasn't worked in quite a while.
> 
> I assumed you and fptech were aware of it.
> 
> Example: You have a records with a set of state fields where 
> {S1) PU State"
> are up to 10 states that the company picks up from and "S2) 
> Delv State" are 10 states the company delivers to.
> 
> If you build an index on s1) as the first criteria and s2) as 
> the second and try to use it to find a company that picks up 
> in say NJ and delivers to CA nothing will be returned, even 
> though many records contain the requested data.
> 
> I understand that the example seems flawed and it should 
> return any record that contains NJ in any of the S1) fields 
> and CA in any of the S2) fields but that's exactly what we 
> want - only nothing is returned.
> 
> Howie
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>