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: u2-users@listserver.u2ug.org
>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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
