Creating variables at run-time

[sebpas]

I need to create variables from a mdb file. The table contains var names and the formula that goes with it. In the formula, you can find another var with it's own formula. I need to put all this in variables (aprox 200) to be able to calculate the formulas.

Ex: var:TEST formula: (TEST2 + 60) / 2
var:TEST2 formula: 40

Each var corresponds to a line in the mdb table.
I've seen 2 dimensional arrays but i'm not sure if it would be the best way to go. Any help would be very appreciated.

 

[WilMead]

A one dimensional array of UDT or objects is easier on the brain. I prefer objects even though they have a litle more overhead.

You have other problems, depth and recursion.

How deep does the parsing have to go?
How do you want to handle recursion?




Wil Mead
wmead@optonline.net