RE: [U2] [UV] The Learning Curve Continues!!
EVERY is a keyword in Universe that will do what you want. From HELP EVERY. | |Use in a selection expression to select a record only if every | |value in a multivalued field meets the specified condition. | |EVERY must be used with the WITH keyword. For example: | | | | LIST INVENTORY WITH EVERY ITEM EQ 'PAPER' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: 24 August 2004 17:29 To: [EMAIL PROTECTED] Subject: [U2] [UV] The Learning Curve Continues!! I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Now ... How do I find records in UV with this statement in UD? SELECT FILE WITH EVERY MULTIVALUE.ATTB # DOG Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want that record selected... I can't find 'each' or 'every' as key words in RetriVe... --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] The Learning Curve Continues!!
1) Quotes work fine with LIKE. Try LIST VOC WITH @ID LIKE ...X... to see the result. 2) File Types and reasons for them (2 through 8) - easiest way to get quick list of the intent of each file type is to type CREATE.FILE XXX and type ? for help at the File Type prompt. 3) EVERY is listed in the VOC as a K-type, meaning it is a keyword. If you type HELP EVERY at TCL, you do get a help entry for this keyword. May I suggest that the two flavors are different, that each has its strengths and weaknesses, and the one you're learning always seems worse than the one you know. ;^) -- James -Original Message- From: David Wolverton [EMAIL PROTECTED] Sent: Aug 24, 2004 9:29 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] The Learning Curve Continues!! I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Now ... How do I find records in UV with this statement in UD? SELECT FILE WITH EVERY MULTIVALUE.ATTB # DOG Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want that record selected... I can't find 'each' or 'every' as key words in RetriVe... --- 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/
Re: [U2] [UV] The Learning Curve Continues!!
SELECT FILE WITH EVERY MULTIVALUE.ATTB UNLIKE ...DOG... - Original Message - From: David Wolverton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 12:29 pm Subject: [U2] [UV] The Learning Curve Continues!! I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Now ... How do I find records in UV with this statement in UD? SELECT FILE WITH EVERY MULTIVALUE.ATTB # DOG Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want that record selected... I can't find 'each' or 'every' as key words in RetriVe... --- 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/
RE: [U2] [UV] The Learning Curve Continues!!
Ya know I don't know what I was typing before to get the error --- but I type the EVERY command now (after a nice lunch) and it works just like it does in UniData... I suspect the issue is my attitude!! I probably made a simple typo and immediately ASSumed it was a difference in UniVerse versus UniData... Be gentle with me while I make this transition... I'm sure I will make several stupid posts between now and NerdNirvana... :-) David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Tuesday, August 24, 2004 11:43 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] The Learning Curve Continues!! EVERY is a keyword in Universe that will do what you want. From HELP EVERY. | |Use in a selection expression to select a record only if every | |value in a multivalued field meets the specified condition. | |EVERY must be used with the WITH keyword. For example: | | | | LIST INVENTORY WITH EVERY ITEM EQ 'PAPER' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: 24 August 2004 17:29 To: [EMAIL PROTECTED] Subject: [U2] [UV] The Learning Curve Continues!! I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Now ... How do I find records in UV with this statement in UD? SELECT FILE WITH EVERY MULTIVALUE.ATTB # DOG Meaning, if there is a DOG *anywhere* in MULTIVALUE.ATTB, I don't want that record selected... I can't find 'each' or 'every' as key words in RetriVe... --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- 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/
Re: [U2] [UV] The Learning Curve Continues!!
In a message dated 8/24/2004 9:36:20 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: I just found out the reason LIKE is misbehaving for me is that I'm 'Quoting' is and should not be The ellipses act like quotes... Got it... Not exactly. You can use quotes but you have to be careful about things that trigger MATCHES. So if you say LIST NAME LIKE ...3N... i think it will try to find any string with three numerics. Or maybe it will if you say LIST NAME LIKE ...3N... one or the other, I just can't recall. Will --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
