Data is being accessed by another...

[MattH]

I wrote a quick applescript to upload an image to a server and then insert it into a container in a new record. I'm sure this has been done a million times by other developers, but I couldn't find an existing script.

The problem is that I get an error message:

filemaker got an error: Data is being accessed by another user, script, or transaction

Unknown Error -10011

The error stops showing up for a while if I swivel my office chair around quickly and then scratch my head, then execute the script. Is there a good way to take the voodoo out of this?

Thanks!

Matt

Applescript:

property filepath  ""

property filename : ""

property imagenumber : ""

property serverpath : ""



set oldDelimiters to AppleScript's text item delimiters -- always preserve original delimiters

set AppleScript's text item delimiters to {":"}



tell application "FileMaker Pro Advanced"

	set serverpath to cell "G_serverpath" of current record

	set imagenumber to cell "key Primary Photo" of current record

	tell application "Finder"

		set filepath to choose file with prompt "Choose a file to import:"

		duplicate file filepath to serverpath

		set filename to last text item of (filepath as text)

		set the name of file (serverpath & filename) to imagenumber & "_" & filename

	end tell

	set cell "File Name" of current record to filename as text

end tell



set AppleScript's text item delimiters to oldDelimiters -- always restore original delimiters

[MattH]

I ran the script from Script Editor and found that the error occurs on this line:

set cell "File Name" of current record to filename as text

The "File Name" field is in the active layout and has no restrictions.

[Fenton]

The voodoo is that you may have had your cursor in a field when you ran the script. AppleScript is considered another user, so is blocked from editing the record which you left open. It's a good idea to put a Commit Record script step before running Perform AppleScript steps.

If you set a field during the AppleScript, then put another Commit Record step after. Or use the AppleScript FileMaker command "save record," which does the same thing from AppleScript.

[MattH]

Fenton:

Your suggestion worked! Thanks much.

What will we do without voodoo?

Matt

[PeterinJapan]

Just wanted to let you know, a random person in Japan was helped by the "save record" suggestion 12 years after this discussion! Cheers and thanks!