dbTalk Databases Forums  

FM11 breaks related records script?

comp.databases.filemaker comp.databases.filemaker


Discuss FM11 breaks related records script? in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bill Steele
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.