Re: Supporting multiple clients with different calculations -- using memo field for varying customer logic??

Author: Stephen Russell

Posted: 2015-11-18 at 08:16:46

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, <

mbsoftwaresolutions@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_zS8A@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.

©2015 Stephen Russell