filemaker show and count events
filemaker show and count events
- Subject: filemaker show and count events
- From: "Jason Miranda" <email@hidden>
- Date: Tue, 21 Aug 2001 17:26:28 -0400
- Thread-topic: filemaker show and count events
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