Nope. The original post requested a method to get a list of IDs when both A and B appear in the multivalued STATUS field, AND the ST_DATE value ASSOCIATED with the "B" STATUS was blank.
Larry Hiscock Western Computer Services -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen Sent: Wednesday, February 18, 2009 11:40 AM To: [email protected] Subject: RE: [U2] Need help with SELECT limiting MV It can....it could be A @ <x,1> and B @ <x,2> but... I read from the original post (between the lines) that only status of A OR B when the ST_date = "" were to be pulled, and not to mix vm lines, that is status and ST_Date of <,x> and only <,x> were to be compared. George > -----Original Message----- > From: [email protected] [mailto:owner-u2- > [email protected]] On Behalf Of Eric Armstrong > Sent: Wednesday, February 18, 2009 1:41 PM > To: [email protected] > Subject: RE: [U2] Need help with SELECT limiting MV > > Even if its multivalued, how can STATUS equal A and B at the same time? > > Eric Armstrong > IT Dept > Lobel Financial > > > -----Original Message----- > From: Larry Hiscock [mailto:[email protected]] > Sent: Wednesday, February 18, 2009 9:59 AM > To: [email protected] > 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: [email protected] > [mailto:[email protected]] On Behalf Of Eric Armstrong > Sent: Wednesday, February 18, 2009 8:10 AM > To: [email protected] > 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:[email protected]] > Sent: Tuesday, February 17, 2009 10:27 AM > To: [email protected] > 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 > [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/ > > 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
