9 Replies Latest reply on Jun 1, 2017 12:09 PM by sfpx

    Perform find: How could this happen ?

    sfpx

      Something really weird happened this week with one of my script and I absolutely don't understand how this was possible.

       

      I have an Archive script that I execute the following way

       

      Perform Script On Server "Archive" params: List(global::User;global::Date)

       

      The archive script looks like

       

      Set Variable $user = GetValue ( Get ( ScriptParameter ) ; 1 )

      Set Variable $date = GetValue ( Get ( ScriptParameter ) ; 2 )

      then a series of blocks like this

      Go to layout [aLayout]

      Perform find (Atable::date<$date and Atable::user==$user)

      Replace Field Contents (Atable::archived; 1)

       

      The last line can also be Delete All records

       

      So basically what happened is that everything was set to archive or deleted.

      Included , for example, everything of Atable::user different than $user and Atable::date >= $date

       

      I tried to replicate the problem (offline) but without any success.

       

      Never had any problem before with this script (online and offline).

       

      I must be missing something .