Bill;
I think this worked. You have accts 2365 and using the with connective it
displays the entire record if any multi-value passes the criteria. The when
you used below is used to remove the multi-values from the listing that
don't pass the criteria - notice how your other example only shows 3 out of
the 5 mv's.
Perhaps this was a bad example. I forget exactly what the original problem
was. However, I think if you use the "with any" construct you can
select/list any records that pass the criteria.
hth
Colin Alfke
Calgary, Canada
-----Original Message-----
From: Bill Haskett
Eric:
[SNIP]
I wouldn't have expected this to work anyway because every MV meets one or
the other of the criteria. The dicts ACCTS and AMTS are associated with
each other. I would have expected the following to work though:
list APOPEN WITH ACCTS UNLIKE "52..." AND WITH ACCTS UNLIKE "29..." INVDATE
COMMENT ACCTS AMTS APOPEN.... INV-DATE DESCRIPTION........................
ACCT. ACCT/AMTS....
58*6-4 06-01-08 LOAN #123456, 06/2008 5230 246.04
2910 1,025.50
2365 61.08
2980 273.70
5230 50.00
Bill
>-----Original Message-----
>From:Eric Armstrong
>Bill,
>Try OR instead of AND.
>
>Eric
>
>
>-----Original Message-----
>From: Bill Haskett
>
>Jeff:
>
>I could only get a single criteria to work...
>
>list APOPEN WHEN ANY ACCTS UNLIKE "52..." INVDATE COMMENT ACCTS AMTS
>APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
>
>58*6-4 06-01-08 LOAN #123456, 06/2008 2910 1,025.50
> 2365 61.08
> 2980 273.70
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
