Try "WHEN" not "WITH" LIST APOPEN WHEN(ACCTS UNLIKE "52..." AND ACCTS UNLIKE "29...") etc
Regards Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathleeni M Hunter Sent: Wednesday, 25 June 2008 12:23 p.m. To: [email protected] Subject: RE: [U2] Friday query logic 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: [email protected] 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: [email protected] 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: [email protected] 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 [email protected] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
