I have a database in which each record represents a story in a magazine.
A portal links to a photo database to show photos that go with the story.

To extract data I have an Applescript like so (oversimplified to one
field and no repeats):

tell application "FileMaker Pro"

tell database "Stories"
tell current record
set storyTitle to cell "title"
do script "RelatedRecords" --Filemaker script: Go to related
record; show only related records
--
end tell
end tell

tell database "Photos"
set oneCaption to cell "caption" of current record
end tell

end tell

This worked find with Filemaker 9 on Leopard. Now we've upgraded to
Filemaker 11 and Snow Leopard.

And now the above errors on the first attempt to read the related
records with "Data is being accessed by another user, script or
transaction."

Worse, *sometimes* it works. For a while. I can sometimes jump start it
by scrolling to an earlier record in the database and then back, or by
quitting Applescript Editor and then starting it again. The actual
script has a lot of looping through records, and when it does work it's
good for about 4 or 5 photos and then it dies. I thought "memory issue,"
but sometimes it just won't run at all, even from a fresh start.

Suggestions?

On 3/31/2011 1:49 PM, Bill Steele wrote:


Use a FileMaker script rather than an APpleScript? Is there a
particular reason you are trying to do this with AppleScript?

In article <in36qb$e4l$1 (AT) news (DOT) motzarella.org>,
Howard Schlossberg <howard (AT) nospam (DOT) fmprosolutions.com> wrote:

1. It has to do some image processing.
2. As previously noted, it used to work perfectly.

However, that might be a fallback if I can't fix this: read the info
with a Filemaker script, then pass it to Applescript for processing.
Except that there's no good way to pass variables from Filemaker to
Applescript. (I know, global fields. Ten in a row?)