Set Field Problem
Seems like this should be simple but I'm getting odd results. I have a script that is supposed to update a set of fields based on a global variable. It reads something like this:
IF [$$globalvar = 1]
SET FIELD [table1::fieldname1; table2::fieldname1]
SET FIELD [table1::fieldname2; table2::fieldname2]
ELSE IF [$$globalvar = 2]
SET FIELD [table1::fieldname3; table2::fieldname1]
SET FIELD [table1::fieldname4; table2::fieldname2]
Instead of getting the VALUES from the fields in table2 to be stored in the fields on table1, it is storing the NAMES of the fields.
Very strange. Anyone have a thought?
While waiting for a reply to this post, I continued messing with the situation. The data in my table2 appears in another layout, not in a portal. Maybe that's the issue. Instead of directly referencing the field in the SET FIELD command, I seem to have solved the problem by storing the value in a local variable and then referencing that variable.