Re: Executing a dynamic formula

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