I tried the 'EVAL "@RECORD<n>"', 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?
SW -----Original Message----- From: Pingilley, Ron [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 9:00 AM To: [email protected] Subject: 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(@RECORD<attribute number>)" LIKE "...HELLO..." That would create an on-the-fly virtual field for the comparison. --Ron P. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
