RE: Executing a dynamic formula

["Jonathan Mason" <jonathan.mason@xxxxxxxxxxxxxxxx>]

Hi Mike

You can use embedded SQL to calculate the formula quite simply.  You can
find an example of how to do this at:

http://www.astradyne-uk.com/code/index.php?id=4c8ad8fbd1

All the best

Jonathan

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of eftimios pantzopoulos
Sent: 03 May 2007 11:24
To: midrange-l@xxxxxxxxxxxx
Subject: Executing a dynamic formula


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