Associated fields in selection table

[John Esak]

I just had to comment. This now confirms my suspicion that there is a
"Esak's Law of Parallel filePro Programming Time-based Coefficient" and the
value is probably -i.  :-)  This _exact_ question came up about 4 weeks ago
and I called Ken about it. He gave me the exact answer he is giving here.
Just proves the law.

Loosely stated... something in filePro doesn't come up for 25 years... and
then within the space of a few days, 15 separate "needs" for that precise
thing come up all together. :-)

This has happened to me on no less than 30 occasions now. It's like finding
an obscure bug that has bothered no one ... ever ... and then one week comes
along and everyone seems to run into it all at once.

Too stragne, but true.

John Esak


> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Kenneth
> Brody
> Sent: Friday, May 26, 2006 1:19 PM
> To: Barry Wiseman
> Cc: laura at gensoftdes.com; filepro-list at lists.celestial.com
> Subject: Re: Associated fields in selection table
>
>
> Quoting Barry Wiseman (Fri, 26 May 2006 12:52:25 -0400 (EDT)):
>
> > Linux rclerk 5.0.14R4.
> [...]
> > The B) fields contain arbitrary text.  I am trying to compose selection
> > tables that will find combinations of keywords, for example:
> >
> >     þ  B) þ B) Memo Description     co þ   emer                þ
> >     þ  B) þ B) Memo Description     co þ   round               þ
> >
> > I find that this will only select records where both strings occur in
> > the *same* field; it will not search all five fields for each string.
> >
> > I sure didn't think this was the expected behavior.
>
> It is.
>
> > How can I do multiple keyword selection against this group of fields
> > using the field association?
>
> Place the statments in separate groups.  If you refer to the same
> associated field group letter within a single selection set group,
> it means that a single instance of the group must satisfy the
> condition.
>
> Consider, for example, searching for someone with "a1) product code"
> equal to "fp56" and "a2) quantity" greater than "10".  (Meaning, of
> course, that the "fp56" quantity was greater than 10.)
>
> [...]
>
> --
> KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list