Using FMPA 8.5

I tried putting this AppleScript directly in a FileMaker script in a file called test1... Idea is from file 1 to open file 2 and set a field...

tell application "FileMaker Pro Advanced"

activate

open file "mydrive:myfolder:Testers:test2.fp7"

set cell "testfield" of current record of database 1 to "stuff"

end tell

When I run this - I get -

" no user interaction allowed"

error =

-1713

- this is just 2 new test files with no privileges - it is set to all access

Q: what's wrong here?

Edited March 12, 200718 yr by Guest

I still could use some help with this... any ideas?

I had trouble with this also. I think the problem is that when FileMaker is running an AppleScript, as opposed to Script Editor or a stand-alone AppleScript applet, it has trouble reaching out to another FileMaker file that is not open.

Because things work fine if the file is already open. But if the file is not open, no matter if I put a delay, it still just sits there waiting, then gives an error that the objects cannot be found.

So, my suggestion would be to either do this stuff with a separate AppleScript file, or alternate between using AppleScript and FileMaker. That is, split the operation up between the 2 files. What is the problem with this? Are you trying to avoid creating, or cannot create, a File Reference between them?

BTW, you'd want to tell application "Finder" to open the file; it will open with its owner, which is FileMaker. FileMaker doesn't "open" files apparently.

tell application "Finder" to open (choose file)