Evaluate_template Array not working

[G Gabriel]

Re: Evaluate_template Array not working

So, ultimately I want this to work:
Code:

vDataHeight = evaluate_template("(vData * Array[" + i + "].vDataField" + m + ")/yMax")

vDataHeight =(vdata*eval("array[i]."+vDataField)+m)/ymax

although, I think you meant vDataField1 not vDataField, but I am not sure if vDataField is another variable.

[Peter.Greulich]

Re: Evaluate_template Array not working

dim array[8] as p
vdatafield = "costs"
i = 1
array[1].costs1 = 10

? "Array["+i+"]." + vDataField + m
= "Array[1].costs1"

? eval("Array["+i+"]." + vDataField + m)
= 10

Stan, it works in your case (and Tom's) because you are explicitly setting the variable to a value. My variable is set to a field name. Please see the attached zip file and look at the script called Array_Test.

I do appreciate all your help.

[Stan Mathews]

Re: Evaluate_template Array not working

I'll try to remember to look again in the morning. I only have v5 at home and I think there are some later version methods in use here.

The post where you had

? eval("Array[" + i + "]."+vDataField + m)
ERROR: Variable "vDataField" not found.

Indicates a different problem of the "vDataField" variable not being established at the time.

[G Gabriel]

Re: Evaluate_template Array not working

unable to open the zip file. Tested the expression I posted earlier in my IW, works fine.

[Peter.Greulich]

Re: Evaluate_template Array not working

Gabe, FWIW: I just downloaded and successfully opened my own zip file.

Remember, I'm substituting a variable for a field name plugged into the array in order to retrieve the field value. See the zip...

[G Gabriel]

Re: Evaluate_template Array not working

I could open it, but the table is lacking the dicitonary and is not recognized by the script.

Remember, I'm substituting a variable for a field name plugged into the array in order to retrieve the field value. See the zip...

I understand what you are trying to do. I did a test table with the expression posted earlier, it works fine.

[Tim Kiebert]

Re: Evaluate_template Array not working

Peter,

This worked for me in your sample

x = eval("Array[i]."+eval("vDataField"+m))

[G Gabriel]

Re: Evaluate_template Array not working

Tim:
This is similar to the expression I wrote earlier, but the zip file is missing some files and the script is not recognizing the table. I knew it should work.

[Tim Kiebert]

Re: Evaluate_template Array not working

I could open it, but the table is lacking the dicitonary and is not recognized by the script.

I did a test table with the expression posted earlier, it works fine.

Gabe, I had to drop the table as it was not pointing to the correct directory and then re add it.

[G Gabriel]

Re: Evaluate_template Array not working

....dropped & added the table, script works fine.

[Tim Kiebert]

Re: Evaluate_template Array not working

Tim:
This is similar to the expression I wrote earlier, but the zip file is missing some files and the script is not recognizing the table. I knew it should work.

Didn't mean to butt in but you were having trouble opening the sample and the parameters were different to what youse were working on before.

....dropped & added the table, script works fine.

can you elaborate on that ie which expression.

Ooops, I see you have posted a sample.

[G Gabriel]

Re: Evaluate_template Array not working

The expression I am referring to is the one I posted earlier:
vDataHeight =(vdata*eval("array[i]."+vDataField)+m)/ymax

[Peter.Greulich]

Re: Evaluate_template Array not working

Tim,

You get the cigar! Thanks so much! I was going nuts. And thanks to Stan and everyone else. I should have posted a working (i.e. not-working) model from the get-go. I think I may have misled some of you by my less than clear script examples.

[G Gabriel]

Re: Evaluate_template Array not working

Peter:
I don't believe you tried the expression I posted long time ago, a simplified version of what Tim later posted.

[Tim Kiebert]

Re: Evaluate_template Array not working

The expression I am referring to is the one I posted earlier:
vDataHeight =(vdata*eval("array[i]."+vDataField)+m)/ymax

Gabe,
Yes I see that now. ( I opened your sample) And had noticed the expression before but

I think may be you didn't pick up that Peter wanted to dynamically choose vDataField1, vDataField2, or vDataField3 by using the value of the variable 'm'. That is why I applied the second eval() as in eval("vDataField"+m).

If I apply my theory to your expression it would change it slightly to

 vDataHeight =(vdata*eval("array[i]."+eval("vDataField"+m)))/ymax