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/
