1 Reply Latest reply on Mar 19, 2013 4:36 PM by philmodjunk

    Status field not updated during loop



      Status field not updated during loop


      FileMaker Pro



      Operating system version

      OSX 10.8.2

      Description of the issue

      I wrote this script that creates records in the same layout that it loops over (see script code below). The only point where it fails now is at the point where I set the "Status" field of the active record to "New". The field value remains unchanged. The point where it updates the "Amount" field to the value of "15" in the newly created record works perfectly. It also loops nicely and ends when the $FoundRecords reaches "0".

      Question: Why doesn't the "Status" field get updated?

      Go to Layout [ “Registrations” (Registrations) ]

      Perform Find [ Specified Find Requests: Find Records; Criteria: Registrations::RegistrationID: “<30” ]
      [ Restore ]

      Set Variable [ $FoundRecords; Value:Get(FoundCount) ]

      Go to Record/Request/Page [ $FoundRecords ]
      Set Field [ Registrations::Status["New"] ]
      New Record/Request
      Set Field [ Registrations::Amount; 15 ]
      Set Variable [ $FoundRecords; Value:$FoundRecords - 1 ]
      Exit Loop