I try it at once(I already tried with EVALUATE alone but it failed)
The Foxil Le 28/10/2014 21:12, Bill Anderson a écrit :
Jean, First, this... (VFP 9 specific) USE ADDBS(HOME(1)) + [Browser.DBF] SHARED NOUPDATE SELECT CAST(EVALUATE([MIN(1, 2, 3, 4)]) AS N(7, 2)) AS MinimumTest FROM Browser INTO CURSOR Test That shows how to use the VFP MIN() function in a SQL Select while formatting the MinimumTest field. So in theory, replace those 4 numbers with your calculations and you're all set. But be careful of NULLs... I'd think about wrapping these 4 numbers with EVL(< subquery >, 0) or even EVL(< subquery >, 10**10) depending on what you want to do with the result when (if?) the subquery returns a NULL. Bill Anderson
_______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
