3 Replies Latest reply on Apr 30, 2013 11:37 AM by philmodjunk

    Set field problem



      Set field problem



           I'm trying to write a date range find script but get a problem with Set Field syntacsis. It always says that an operator is expected here (see the screenshot attached).

           I'm sure, I'm doing something wrong. Please, help.




        • 1. Re: Set field problem

               When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.

          • 2. Re: Set field problem

                 I've specified target field at Set Field as MyTable::DateTime

                 I'm trying, to create the expression:

                 Globals::gStartDate &...& Globals::gEndDate

                 but get the pop-up window "This number cannot be evaluated".

                 What Am I doing wrong?



            • 3. Re: Set field problem

                   The ellipsis is text and should be enclosed in quotes:

                   & "..." &

                   You may be interested in this thread. It provides a number of examples of setting up scripted finds using global fields and the set field step: Scripted Find Examples