Does anybody remember the 'EVAL' command in Basic? It allows you to
compose a
string variable, e.g. A$="((127-82)/42)*27.5" and then assign the value of
the string into
a numeric variable, i.e. A=EVAL(A$).
Currently I am using a SQL query to do this calculation for me and it is
proving inefficient.
I'm sure there is a 'text book answer' for this solution, something along
the lines of calling a function
with a pre-constructed string, and for it to return the evaluated answer
with a level of decimal
precision.
Any ideas would be gratefully appreciated.
Paul Wheeler.