Re: filemaker show and count events
Re: filemaker show and count events
- Subject: Re: filemaker show and count events
- From: Jason Bourque <email@hidden>
- Date: Tue, 21 Aug 2001 18:08:08 -0400
On 8/21/01 5:26 PM, "Jason Miranda" <email@hidden> 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
Try
Tell document "test.fp5"
Instead of
tell database "test.fp5"
Jason Bourque