MACSCRPT Archives

December 2006

MACSCRPT@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Bill Steele <[log in to unmask]>
Reply To:
Macintosh Scripting Systems <[log in to unmask]>
Date:
Thu, 7 Dec 2006 17:44:08 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (35 lines)
>  > I'm trying to read information from a series of portal rows.
>>  Applescript apparently knows nothing about related records. So, a
>>  Filemaker script:
>>
>>  Go to Portal Row [First]
>>  loop
>>  perform Applescript (read the cells and write to a file)
>>  Go to Portal Row [Next; Exit after last]
>>  end loop
>>
>>  I can see it highlighting one portal row after another, but it just
>>  reads the cells in the first row as many times as there are related
>>  rows. How do I get to read all related records?
>>  --
>
>You're doing things the hard way. Ask directly for what you want, while in
>the parent record.
>
>tell application "FileMaker Developer"
>     cell "Payments::DatePaid" of current record
>end tell
>
>Result - list of related data from the portal in portal row order:
>
>{"6/11/2006", "8/6/2005", "7/17/2004", "6/27/2003", "7/5/2002", "6/15/2001",
>"7/16/2000", "7/25/1999", "8/4/1998", "8/21/1997", "7/10/1996", "7/10/1996",
>"1/20/1995", "1/20/1995", "8/24/1994", "7/26/1994", "5/31/1993"}

Maybe that works in Filemaker Developer, but it doesn't work for me 
in Filemaker 8. Perhaps in 8.5?
-- 

Bill Steele
[log in to unmask]

ATOM RSS1 RSS2