John said >>The EVAL is nice on the fly, but having an I-Desc that does the uppercase r you means it is always there. Give these I-Descs a consistent naming >>convention (always starts with a "U." or ends with a ".U") and you are set for live.
Actually, I did go ahead and took the time to make a virtual attribute called UC_TECH. It's a technician name field. 001: V 002: F15 003: MCU 004: 005: 25L 006: S Now my SELECT statement is much simpler ECMD = "SSELECT ":WO ECMD := " BY WO_DATE BY SHIFT BY DEPT BY PRIORITY BY TYPE" ECMD := " WITH STATUS = 'CLOSED'" ECMD := " AND WITH UC_TECH LIKE '...":TECH:"...'" And it works like a charm. This list is great. I don't know how I got anything done without it. Thanks everyone. Charles Shaffer Senior Analyst NTN-Bower Corporation _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
