FM11 breaks related records script? -
12-10-2010
, 02:26 PM
I have an Applescript that cycles through a series of records and reads
data from records in a portal in each one. After I upgraded to FM11 I
get an error "Data is being accessed by another user, script or
transaction" on the request for the first record in the portal. Usually
this error happens when you don't commit a record before running a
script, but that's not what's happening here, and no, no one else has
the record open. I can't *prove* that it's FM11's fault,. but I've
eliminated most everything else.
Here's a shortened version of the Applescript:
tell application "FileMaker Pro"
tell database "stories"
tell current record
set storyTitle to cell "title"
do script "RelatedRecords"
end tell
tell database "Photos"
repeat
tell current record
set theCaption to cell "caption"
end tell
do script "GotoNext"
end repeat
end tell
end tell
end tell
Related Records is a Filemaker script:
Go to Related Record [Show only related records] From table "photos"
External <Current Layout>
Go to next is just that:
Go to Record/Request/Page [Next]
A script that just opens and reads "photos" works fine. It's something
about going to it as a related record. |