I have an AppleScript that tries to create a new record and insert data into that record on a remote host. The remote host is running FileMaker v8.0.1.

When I run the script, the remote database creates the new record, then raises an "Object Not Found" error. FileMaker is telling me that it cannot find the new record that it just created, despite creating the new record and returning a row id! Here's the relevant part of the script:

set newRec to create new record

  tell newRec

    set cell "ID" to item 1 of d

    set data of cell "client" to item 2 of d

    set data of cell "title" to item 3 of d

    set data of cell "responsibility" to item 4 of d

    set data of cell "type" to item 5 of d

  end tell

I tried using "create new record with data {}", but, again, FileMaker created the new record and then raised the "Object Not Found" error. I tried creating the new record and then using "go to" the record to make sure that I was accessing the proper record, but the hosted database again raised the "Object Not Found" error.

Again, for all attempts, FileMaker creates the record and returns a row id for that record, then raises the "Object Not Found" error when asked to insert data into that new record.

Does anyone have any insight as to what is going on here?

Thanks.

"The remote host is running FileMaker v8.0.1."

It might not help this problem, but update it to 8.0v4. FMS 8.0v1 had some bugs, as did v2 and v3. :

I found the solution on the AppleScript users list. You need to create the new record with data at the table of the database you want.

tell application "FileMaker Pro"

  create new record with data {"my_client"} at table "my_table" of database "my_database"

end tell

Notice that you can't tell the database or tell the table to create the new record.