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

Author: Ken Dibble

Posted: 2015-11-18 at 08:41:07

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

If the problem is finite, then, yes, pre-coded and compiled programs

are the best option. I didn't read the question that way.

If the set of possible formulas is not fully defined and is known to

be likely to change rather frequently, then the formulas should be

stored as data.

As for typos, people put their own formulas into Excel all the time,

and lots more complicated than the ones in this situation, and they do fine.

As for the dreaded memo file corruption problem in VFP, it's easily

and almost completely preventable by good programming practices, and

completely trivialized by good backup practices. I haven't had a

corrupted memo file since the early 2000s.

But I did point out that the formulas could also be stored in

limited-length character fields instead of memos.

Ken Dibble

www.stic-cil.org

_______________________________________________

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/D2.9A.32480.04E8C465@cdptpa-oedge03

** 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 Ken Dibble