I use a bitwise operation on a column for this type of potential growth. When defining what goes on a page how many radio buttons do you need?
1, 10, 11, 100,101, 111,... I can now track that specific text in a db and edit it there. But formulas for something very specific items like this is a lot more complex. The try catch around this now needs a lot more work to identify what might be wrong with "text" On Wed, Nov 18, 2015 at 8:41 AM, Ken Dibble <krdib...@stny.rr.com> wrote: > > 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 > > [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/CAJidMYKg1e6uL-nECuoXYo1x9FtTnMVt2N2Jo+dCAdDPzY=h...@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.
