I wonder how the new (in 9) ICASE function stacks up performance-wise. Have you tried it? I would think a single inline function would run faster than nested IIFs but as the wise around hear always say, test, test, test...
Jeff Johnson wrote: >>>> Peter: I went to one of Andy Kramek's sessions at Whilfest one year on >>>> optimization of VFP. While the nested IIF's can get messy, they are >>>> significantly faster than CASE, IF-ELSE-ENDIF or using a UDF. I find >>>> > Michael: The grid highlighting occurs each time the status of a record > changes. Many records can have their status change by various methods. > Originally this was done with a case statement in a method of the form and > the painting of the grid was not acceptable. > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Australian Support - [EMAIL PROTECTED] Internet Support - [EMAIL PROTECTED] All Other Requests - [EMAIL PROTECTED] --------------------------------------------------------- This message has been checked for viruses before sending. --------------------------------------------------------- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

