selection set with dates on diff fields don't work

[Dennis Malen]

Ken,

If  I use the selection set with field 5 only and delete field 97 it chose a
record that contained a field 5 date of "04/04/19" and field 2 of  "0642".

The same result when I use field 97 only, I got "05/13/04" with the
appropriate field 2 selection.

In both cases I receive more than one response which met the selection
criteria in each instance.

I can't figure this one out. The selection format is used in inquire, update
and add. I also have a report where I initially attempted to use this
selection format (that's why I experimented in rclerk) and it did not
work.What I have done on the report is to put processing in that would look
for field 5 in the selected record while using field 97 in the selection
format and does not recognize field 5 in the processing. For some reason it
does select those records which fall into the selection format (date field
97 only) but does not seem to recognize the condition created for date field
5 in the processing

Remeber field 5 is a date field "ymd/" and 97 is "mdy/". Could this be the
problem. In the selection format different date edits can not coexist. It
doesn't make any sense but that is what happens. If the dates are used
uniquely in both the selection format and to processing table, then it
works. Otherwise it does not.

I don't want to confuse the issue with the report format but that is how I
got to the selection format in dclerk to test what it was doing. So let's
just stick with the selection format in dclerk as opposed to being
sidetracked by the processing in rreport even though the same thing happens
in the processing table.

Dennis Malen
516.479.5912

----- Original Message -----
From: "Kenneth Brody" <kenbrody at bestweb.net>
To: "Dennis Malen" <dmalen at malen.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Wednesday, April 21, 2004 6:42 PM
Subject: Re: selection set with dates on diff fields don't work


> 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?
> [...]
>
> Assuming you have a record whose client# is any of 0593/0594/0642, has
> a status changed date of 21-Mar-04 or later, and has an assigned date
> of 8-Apr-04 or later, then the above should work.
>
> Can you give examples of actual data that "work" when using either date
> field but not when using both?
>
> --
>
+-------------------------+--------------------+----------------------------
-+
> | Kenneth J. Brody        | www.hvcomputer.com |
|
> | kenbrody at spamcop.net | www.fptech.com     | #include
<std_disclaimer.h> |
>
+-------------------------+--------------------+----------------------------
-+
>
>
>
>