AnsweredAssumed Answered

Question on SET FIELD BY NAME

Question asked by MorkAfur on Sep 17, 2012
Latest reply on Sep 17, 2012 by MorkAfur

Title

Question on SET FIELD BY NAME

Post

     Hello,

     I have a simple script where I'm trying to copy a UUID-generated script value from a field in one table to it's currently-blank related field in another table. (The reason the field is blank in the related table is that I'm using an CSV file to populate the first table with 50,000 records).

     When I try to run the script below, the target field does not get populated. The Script Debugger isn't helpful in seeing what's going on. The $ variable is being set correctly in each row of the initial table.

     Here's the script. Any suggestions welcome! :)

     Go To Layout Table1

     Go to Record/Request/Page [First]

     Loop

        Set Variable [$var1; Value:Table1:id]

        Set Field By Name[Table2::idFromTable1; $var1]

        Go To Record/Request/Page [Next; Exit after last]

     End Loop

     Why doesn't that work?

     Thanks in advance.

     -m

Outcomes