In this statement: LIST TAB WITH F2 = "A" WHEN F2="B" AND F3="" F1 F2 F3
There is an implied "OR" before the "WHEN" so the statement actually is LIST TAB WITH F2 = "A" or WHEN F2="B" AND F3="" F1 F2 F3 An OR will break the statement in two making the results in the list either what is on the left side OR what is on the right side. In other words: LIST TAB WITH F2 = "A" OR WHEN (F2="B" AND F3="") F1 F2 F3 Jerry Banker -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Wednesday, February 18, 2009 11:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help with SELECT limiting MV Ummm ... you can when Status is a multivalued field, which was described in the original post. Larry Hiscock Western Computer Services -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Eric Armstrong Sent: Wednesday, February 18, 2009 8:10 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help with SELECT limiting MV Noah, Try SELECT TAB WITH (STATUS = "A" OR STATUS = "B") AND ST_DATE = "" You can' have status equaling A and B at the same time! Eric Armstrong IBM Certified Solutions Expert- U2 Family Application Development Software Applications Developer/Analyst Lobel Financial -----Original Message----- From: Noah Hart [mailto:n...@lipmantpa.com] Sent: Tuesday, February 17, 2009 10:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] Need help with SELECT limiting MV I have a table with a MV status code and date field. I am trying to select just those records that have both status code A and B and when the date associated with code B is blank I tried SELECT TAB WITH STATUS = "A" AND STATUS = "B" AND ST_DATE = "" But this will select records which might have a blank date for status "C" I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = "A" WHEN F2="B" AND F3="" F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. ------- 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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/