3 Replies Latest reply on Mar 10, 2011 1:03 AM by hbrendel

    An operator is expected here error message

    lyndon

      Title

      An operator is expected here error message

      Post

      I'm a beginning FileMaker Pro user and I'm doing the lessons in the FileMaker Pro Training Series book. When doing a calculation example exercise many times I get an error message that says "an operator is expected here." I go back and review my entries but they are exactly as they are in the book. Can anyone tell me what I'm doing wrong? Thanks

        • 1. Re: An operator is expected here error message
          hbrendel

          Post the calculation here

          • 2. Re: An operator is expected here error message
            lyndon

            Here is my calculation post:

            /Given a label code this function will return the corresponding field.

            case (

              Lower ( label ) = “meeting title”; MEETING::Title”;

            Lower ( label ) = “leader” ; “meeting_PERSON_leader::NameFirstLast”;

            Lower ( label ) = “date”; MEETING::/date”;

            Lower ( label ) = “start time” “MEETING::TimeStart

            Lower ( label ) = “end tinme”; “MEETING::TimeEnd”;

            Lower ( label ) = “location”; "MEETING::Location”;

            "NULL”

            )


            • 3. Re: An operator is expected here error message
              hbrendel

              Don't put parenthesis around field names. This should normally not give the error, but it would give you wrong results.

              The error is caused by the fact that two field names just have one parenthesis. The 4th case condition lacks semicolons.

              I assume that your date field's name is not "/date" but "date".

              Your statement "... but they are exactly as they are in the book" cannot be true in my opinion.

              The corrected code:

              Case ( 

              label  = "meeting title" ; MEETING::Title ;

              label = "leader" ; meeting_PERSON_leader::NameFirstLast ;

              label = "date" ; MEETING::date ;

              label = "start time" ; MEETING::TimeStart ;

              label = "end time" ; MEETING::TimeEnd ;

              label = "location" ; MEETING::Location ;

              "" 

              )

              1 of 1 people found this helpful