2 Replies Latest reply on Aug 11, 2011 12:06 AM by sakra

    Porting FileMaker AppleScript from 5.5 to 11

    sakra

      Title

      Porting FileMaker AppleScript from 5.5 to 11

      Post

      Hi,

      I am porting an AppleScript which worked fine with FileMaker 5.5 to FileMaker 11. The AppleScript uses a whose clause which does not seem to be handled by FileMaker 11 at all:

      getcell "#NumberKey" ofrecord 1 ofdatabase "GlobalNumbers"

      --> "10"

      getrecord 1 ofdatabase "GlobalNumbers" whosecell "#NumberKey" = "10"

      --> error "Event not handled." number -1708

      The database contains a text field "#NumberKey". The first record contains the value "10". Searching for that record by using a whose clause does not returned the existing record.

      How can I make the whose clause work with FileMaker 11?

      Thanks,

      Sascha