Don't you love having lots of cool ways with FoxPro to solve the same problem? :)
Paul H. Tarver Tarver Program Consultants, Inc. Email: [email protected] -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Gene Wirchenko Sent: Sunday, July 09, 2017 11:35 PM To: [email protected] Subject: RE: numeric overflow At 11:57 2017-07-07, "Paul H. Tarver" <[email protected]> wrote: >I sometimes run into this with variables and/or fields. In either case, >you can pre-test a value and/or format using the transform() function as well. > >If TRANSFORM(a,"@L 999.99") = "***.**" >Endif > >The nice thing about this method is you can control exactly the format >of the value you are testing. > >Alternate test: > >If occurs('*',TRANSFORM(a,"@L 999.99") ) > 0 Endif Or the condition "*"$transform(...) [snip] Sincerely, Gene Wirchenko [excessive quoting removed by server] _______________________________________________ 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.

