selection set with dates on diff fields don't work
Jay R. Ashworth
jra at baylink.com
Wed May 26 10:31:34 PDT 2004
On Wed, Apr 21, 2004 at 04:11:42PM -0400, Dennis Malen wrote:
> Here's an interesting one. The following is a selection set where records in
> the file should meet the selection criteria but filepro does not select the
> record as meeting that criteria.
>
> : 97 : Date Status Changed ge : 03/21/04
> a : 2 : Client# : 0593
> a : 2 : Client# : 0594
> a : 2 : Client# : 0642
> : 5 : Date Assigned ge : 04/04/08
>
> Field 97 has an edit of mdy/ and filed 5 has an edit of ymd/.
>
> If fields 97 and 5 are used separately its works fine. When both are used as
> above they select nothing. Am I restricted from using two different date
> selections on two different fields?
Well, my snap reaction is "if you're using letters in your selset, use
them on *all* lines, and write a selection sentence", but that's
probably just because I can't ever remember the rules properly.
You might try that, though, and see what happens.
Cheers,
-- jra
--
Jay R. Ashworth jra at baylink.com
Member of the Technical Staff Baylink RFC 2100
The Suncoast Freenet The Things I Think
Tampa Bay, Florida http://baylink.pitas.com +1 727 647 1274
"They had engineers in my day, too." -- Perry Vance Nelson
More information about the Filepro-list
mailing list