Eric:
That doesn't work either.
list APOPEN WITH ANY ACCTS UNLIKE "52..." OR WITH ANY 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
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: [EMAIL PROTECTED] [mailto:owner-u2-
>[EMAIL PROTECTED] On Behalf Of Eric Armstrong
>Sent: Monday, June 23, 2008 12:47 PM
>To: [email protected]
>Subject: RE: [U2] Friday query logic
>
>Bill,
>Try OR instead of AND.
>
>Eric
>
>
>-----Original Message-----
>From: Bill Haskett [mailto:[EMAIL PROTECTED]
>Sent: Monday, June 23, 2008 11:19 AM
>To: [email protected]
>Subject: RE: [U2] Friday query logic
>
>
>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
>
>...or...
>
>list APOPEN WHEN ANY 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
> 2365 61.08
> 5230 50.00
>
>...but adding both criteria together with an AND/OR failed...
>
>list APOPEN WHEN ANY ACCTS UNLIKE "52..." AND WHEN ANY 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
>
>...using WITH instead of WHEN had no effect...
>
>list APOPEN WITH ANY ACCTS UNLIKE "52..." AND WITH ANY 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
>
>This is on UD v7.1.9 (Windows 2K3). Did I miss something?
>
>Bill
>
>>-----Original Message-----
>>From: [EMAIL PROTECTED] [mailto:owner-u2-
>>[EMAIL PROTECTED] On Behalf Of Jeffrey Butera
>>Sent: Monday, June 23, 2008 10:20 AM
>>To: [email protected]
>>Subject: Re: [U2] Friday query logic
>>
>><quote who='Eric Armstrong' date='Monday 23 June 2008'>
>>> Jeff,
>>> In Universe there is a (apparently undocumented) keyword ANY which can be
>used,
>i.e.
>>>
>>> SELECT FILE WITH ANY FIELD UNLIKE SF... OR WITH ANY FIELD UNLIKE SH...
>>>
>>> which may be just what you want.
>>
>>Eric:
>>
>>You get the prize - I'm on Unidata but ANY works the same and it's exactly
>>what I want. On your next hot day I owe you a cool beverage of your
>>choice...
>>
>>
>>--
>>Jeff Butera, Ph.D.
>>Administrative Systems
>>Hampshire College
>>[EMAIL PROTECTED]
>>413-559-5556
>-------
>u2-users mailing list
>[email protected]
>To unsubscribe please visit http://listserver.u2ug.org/
>
>
>
>LOBEL FINANCIAL PRIVACY NOTICE:
>This communication may contain confidential company information that is
>protected by federal law. Federal regulations prohibit the disclosure (or re-
>disclosure) of confidential information without the written consent of the
>person(s) to whom it pertains. Additionally, the views or opinions presented in
>this email are solely those of the author and do not necessarily represent
>those
>of the company.
>-------
>u2-users mailing list
>[email protected]
>To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
