Re: Executing a dynamic formula

[Richard ECUYER <recuyer@xxxxxxx>]

Here is the link.

http://code.midrange.com/index.php?id=72a5b34df4

Thank you 
rob.                                                                               

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