If this is not working, create a dictionary item that does the
evaluation you want and have it return a 1 if it meet the condition and a 0
if it does not.
Dictionary would look like
IF FIELD[1,2] # "SF" OR FIELD[1,2] # "SH" THEN 0 ELSE IF
CONVERT("SH","",CONVERT("SF","",OCONV(FIELD,"MCA"))) # "" THEN 0 ELSE 1
Then you would be a select based on this dictionary be equal to a 1.
-----Original Message-----
From: Eric Armstrong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 1:17 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic
Bill,
Sorry for not responding sooner, but I agree with the comment below. It
should work! So if it doesn't, we have to step back and start asking other
questions.
Eric
-----Original Message-----
From: JPB-U2UG [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 11:24 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic
I take it that you checked to make sure that the fields were associated so
let's take a different look. Are the values separated by value marks or
sub-value marks? What does the dictionary contain? What does the record
below look like in the editor?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Tuesday, June 24, 2008 12:12 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic
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
-------
u2-users mailing list
u2-users@listserver.u2ug.org
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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
