Re: Executing a dynamic formula

[Richard ECUYER <recuyer@xxxxxxx>]

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