× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



hi,

I have an old RPG that do what you want.
It accept a formula and make the calculation.

You can use :

* +, -, *, /
* () and so ....

usually, i make the formulat with variables (&fieldname) and replace them with the user data.
I can send you a copy of the source... only the formula
here is a sample :



eftimios pantzopoulos a écrit :
I was wondering if anyone has solved this type of problem:

I work for a large leasing company and the business has been asking about the possibility of creating functions and running them dynamically. In other words, a user would be able to create a string in a reference table such as result = (amount/term)* interest rate and then have that formula run, with values substituted at execution time.

They may then decide to tweak the formula next month to result = (amount/term)* interest rate + 100.00 so tht it runs without any coding changes. In other words, a dynamic EVAL.

I think I could do it with QSHELL by placing the formula in a QSHELL script dynaically and then executing the script to derive the result but it's not very elegant.

I've heard that VB has a function which accepts the formula as a string and returns a result, but I haven't been able to find it.

Thanks,

Mike Pantzopoulos

_________________________________________________________________
Advertisement: 1000s of Sexy Singles online now at Lavalife - Click here http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Flavalife9%2Eninemsn%2Ecom%2Eau%2Fclickthru%2Fclickthru%2Eact%3Fid%3Dninemsn%26context%3Dan99%26locale%3Den%5FAU%26a%3D27782&_t=762255081&_r=lavalife_may07_1000sexysingles&_m=EXT


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.