Jun 14, 2012 at 7:28 PM
Edited Jun 14, 2012 at 7:31 PM
I load formulas at run time from a database and the values of variable (used in the formulas) comes from a different source. The formulas and the variables are stored in two separate dictionaries.
Dim dctFormulas as new dictionary(of string, string)
dctFormulas.Add("f1", "if(v1>v2 and v3<v4, 'True', 'False')") 'formula Name and expression
At runtime I need to know variable names (v1,v2...) used in the formula(f1) so that I can do the following
Dim exp1 = New Expression(dctFormulas("f1"), EvaluateOptions.IgnoreCase)
exp1.Parameters(variableName) = value