RE: [U2] EVAL keyword -- was: uv pe
John, Per the Unidata 6.1 manual on the IBM web site: EVAL Syntax EVAL expression Description --- The UniQuery EVAL keyword allows you to define a virtual attribute expression for the current execution of a UniQuery statement only. expression can be any expression valid in a virtual attribute. You must enclose expression in single or double quotation marks. Note: UniQuery only supports the EVAL keyword in ECLTYPE U. -- You could do something like this (at least in UniVerse :) SELECT blah WITH EVAL UPCASE(@RECORDattribute number) LIKE ...HELLO... That would create an on-the-fly virtual field for the comparison. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 17, 2005 6:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe snip converts criteria into caps for comparison. E.g. SELECT blah WITH UPCASE(x) LIKE ...HELLO... snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] EVAL keyword -- was: uv pe
I tried the 'EVAL @RECORDn', but can't seem to get it to work. I've always had to resort to referencing the DICT ID for that loc, and we're using UD. Is there an options setting that would enable this for me? For some reason (a bug?), the varf syntax does not work in Unidata I-types and hence EVAL expressions. You need to write this as EVAL EXTRACT(@RECORD,n,0,0) Maybe one day someone will fix this. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] EVAL keyword -- was: uv pe
That works. Thank you. SW -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] EVAL keyword -- was: uv pe For some reason (a bug?), the varf syntax does not work in Unidata I-types and hence EVAL expressions. You need to write this as EVAL EXTRACT(@RECORD,n,0,0) Maybe one day someone will fix this. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] EVAL keyword -- was: uv pe
Really?! Yuck. I never knew that. That's just plain mean. 2nd good candidate today for www.u2ug.org forums enhancements. I tried the 'EVAL @RECORDn', but can't seem to get it to work. I've always had to resort to referencing the DICT ID for that loc, and we're using UD. Is there an options setting that would enable this for me? For some reason (a bug?), the varf syntax does not work in Unidata I-types and hence EVAL expressions. You need to write this as EVAL EXTRACT(@RECORD,n,0,0) Maybe one day someone will fix this. Martin Phillips Ladybridge Systems --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
