Re: filemaker show and count events
Re: filemaker show and count events
- Subject: Re: filemaker show and count events
- From: Malcolm Fitzgerald <email@hidden>
- Date: Wed, 22 Aug 2001 10:23:49 +1000
You get what you ask for.
When you talk to the "database" of filemakerPro you are talking to
every single record. When you use "show" you command the database to
generate a "document" which is transient and, for example, allows you
to see only ten of the 804 records in the "database".
To talk to the transient "document" you should "tell document"
tell document "test.fp5" of application "filemaker pro" to count every record
At 5:26 PM -0400 21/8/01, Jason Miranda wrote:
Hi all,
I am trying to get a count of the records matching certain "show"
criteria.
The example I'm working on is a database containing 804 records. I'm
searching for cells whose values match "01." There are 10 records in the
database that match that criteria.
Here is what I wrote:
tell application "filemaker pro 5"
tell database "test.fp5"
show (records where cell "input04" is "01")
count of record
end tell
end tell
The show command works fine. I get my set of 10 found records. But, the
count record command results in 804 records. Filemaker's Apple Events
Reference database lists the results of the "count of records" and
"count of record" commands as "found records in a file (include found
set)." The same result is given if you use the alternate "create
request" command.
Is there a way to get a count of the found set?
Thanks,
Jason Miranda
_______________________________________________
applescript-users mailing list
email@hidden
http://www.lists.apple.com/mailman/listinfo/applescript-users
--
Malcolm Fitzgerald
Database Manager
The Australian Society of Authors
ph: 02 9318 0877 fax: 02 9318 0530 email: email@hidden
www.asauthors.org www.asauthors.org/award www.asauthors.org/web_of_poets