FWIW. There are a limited number of solutions to this correct? I'd test for a column FormulaType and if present then get that value for their "process"
Your code base now includes a case statement for that value and does the correct calculation from there. Formula in a memo field can get botched either by a file problem or a human editing one. YMMV On Tue, Nov 17, 2015 at 3:31 PM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > VFP9SP2 > > I've got a legacy app from 2003 that's still in use today and showing no > signs of changing. Woo hoo! :-) Now for the question. Say you've got > the following fields: > > Cost > Tax > Overhead > Margin (or Markup) > > ...and the customers want to do different calculations. Customer Jones > wants his cost to be calculated this way: > > Jones_Total = (Cost * Tax%) + Overhead (% added) on that subtotal, and > then Markup after that > > Customer Smith wants to calculate differently: > > Smith_Total = (Cost + Overhead% + Markup) + Tax% > > The object variables are all the same, so it's just a matter of > re-arranging the formula per client's desire. > > I'm trying to think of a meta-way of doing this, storing code in the > database so I don't hardcode anything in the app. Storing the code in a > TEXT (memo) file and then doing something like EXECSCRIPT or something > similar. > > Suggestions? > > tia, > --Mike > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/cajidmyj7ctpbt8lzhhr2nexvsfxpm9p8whv+923hbazbe_z...@mail.gmail.com ** 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.