Mime-Version: |
1.0 (Apple Message framework v1084) |
Sender: |
|
Subject: |
|
From: |
|
Date: |
Thu, 31 Mar 2011 16:51:56 -0400 |
Content-Transfer-Encoding: |
quoted-printable |
Content-Type: |
text/plain; charset=us-ascii |
Reply-To: |
|
Parts/Attachments: |
|
|
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 fails 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. Including a restart of the computer.
Suggestions?
Bill Steele
[log in to unmask]
|
|
|