Open Menu
Close Menu
Apple
Shopping Bag
Apple
Mac
iPad
iPhone
Watch
TV
Music
Support
Search apple.com
Shopping Bag
Lists
Open Menu
Close Menu
Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists
Re: More FMP8 Questions
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Re: More FMP8 Questions
Subject
:
Re: More FMP8 Questions
From: Jeremy Sellors <
email@hidden
>
Date: Fri, 26 Jan 2007 19:25:22 -0800
I am not sure if this is any help but you can use a find request if what you want is an id list of "Open records"
tell application "FileMaker Pro Advanced" --8.5v1
activate
tell document 1 -- or quote name
set ActiveWindow to name of window 1
set ActiveLayout to name of current layout
set layoutTable to name of current table
show every record of table layoutTable
end tell
tell current layout
try
delete every request
end try
set x to create request
set cell "Status" of request 1 to "open"
find of ActiveWindow
set theIDList to cell "ID" of every record
set CountOfRecords to record count
set CountOfRecords to CountOfRecords as string
if (count of records) = 0 then
display dialog "No records found" buttons "OK"
return
end if
end tell
display dialog CountOfRecords & " Records Found:" & return & theIDList buttons "OK" giving up after 5
end tell
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives:
http://lists.apple.com/mailman//archives/applescript-users
This email sent to email@hidden
Prev by Date:
Re: More FMP8 Questions
Next by Date:
Address Book Text Color
Previous by thread:
Re: More FMP8 Questions
Next by thread:
applescripting the calculator
Index(es):
Date
Thread