Didn’t t know about the indent, will do so in the future.
It’s a very old DB that accumulates annual giving totals, essentially just a spreadsheet. I could easily create something new, but it is intertwined with lots of others, so you know how that goes. It seems to be working fine with the other DBs at this point, just gradata( fails.
The field names represent years, I’m curious what best practices would be if not name the fields by years. Just add a letter to the number to guarantee it is alpha-numeric? Like “18Y”?
Just tried:
message ?(grabdata("",array(lvTheList,1,¬))≥350,str(«memno»),“x”) stop
and it returns the correct result,as does fieldvalue( . So could it be something in arrayselectedbuild?
Update 2:
This returns the correct result
message fieldvalue("",1)
however this returns an array made up of only 1’s for all the records instead of the field value or memo. 1 is the value of the first record, first field
arrayselectedbuild lvArList,¶,"",?(fieldvalue("",1)≥350,str(«memno»),fieldvalue("",1))
It appears the calculation is not taking place properly.
If I switch to fieldvalue("",2), which for the first record is 0, I get an array of 0’s. If I try fieldvalue("",4), the value of which is 500, it returns and array of 500’s, etc.
Taking the calculation out of it with:
arrayselectedbuild lvArList,¶,"",fieldvalue("",4)
results in an array of 500’s, which again is the value of the 4 field in the first record.
So, does fieldvalue( not work in arrayselectedbuild?