Goo'day,
At 10:40 18/02/05 +1100, you wrote:
John,when you create a dictionary entry like this, the data is not stored but generated at run time. In UV (I don't know about UD) you can also use the EVAL statement in a SELECT which does this kind of thing at runtime eg:I want to do). The best answer I got was create a virtual field that stored the field in caps and then use that in the select. In fact, the example in an old Unidata manual I found says to do just that. Perhaps there is good reasoning behind that method, but the logic of it completely escapes me.
SELECT MYFILE WITH EVAL "UPCASE(@ID)" LIKE "...HELLO..."
Works on UniVerse.
Have a look at HELP EVAL from TCL.
Or, you could use a "MCU" conversion ......
Craig ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 265.8.9 - Release Date: 17/02/05
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 265.8.9 - Release Date: 17/02/05
Regards,
Bruce Nichol Talon Computer Services ALBURY NSW 2640 Australia
http://www.taloncs.com.au
Tel: +61 (0)411149636 Fax: +61 (0)260232119
If it ain't broke, fix it till it is!
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 265.8.9 - Release Date: 17/02/05
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 265.8.9 - Release Date: 17/02/05 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
