AnsweredAssumed Answered

Set Field Problem

Question asked by ruhlanma on Sep 10, 2013
Latest reply on Sep 11, 2013 by philmodjunk

Title

Set Field Problem

Post

     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]

     END IF

      

      

     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. 

      

Outcomes