1 Reply Latest reply on May 19, 2012 7:34 AM by davidanders

    Insert records using AppleScript into a remote Filemaker DB

    SamsEcke

      Title

      Insert records using AppleScript into a remote Filemaker DB

      Post

      All,

      I want to connect to a remote filemaker DB using AppleScript and insert records into a table. Here is the piece of code that I have come up with so far:

       

      tellapplication "FileMaker Pro Advanced"

      getURL "FMP12://XX.XXX.XX.XXX/Test.fmp12"

      telldatabase "Test"

      settheRecordtocreatenewrecordattable "table1"

      tell theRecord

      setcell "fname" to "Test"

      setcell "lname" to "Test"

      setcell "age" to 25

      setcell "email" to "test@yahoo.com"

      endtell

      endtell

      endtell

       

       

      When I run this script, I keep getting the following error:

      error "FileMaker Pro Advanced got an error: The event failed." number -10000.

      I'm using FM Pro version 12 and I'm on a Mac OSX 10.7.4