Count ... Document not returning Found Count

[jscooper]

Everything I've read so far says that the document class refers to the found set of a database. But when I run the following:

-- already declared lst and filename

tell database FileName

delete every request

repeat with i from 1 to (count of items in lst) -- a list of IDs

set r to (create new request)

set cell FindField of r to (item i of lst) as text -- Look in FindField for matching IDs end repeat

find

display dialog (count records of document FileName)

end tell

It returns the record count (all records in the database), not the count of the resulting found set. I must be missing something obvious; I'd appreciate any help.

Thanks,

Jeff

[jscooper]

Found the problem. Having "count records of document FileName" inside the tell database block confuses it even though I specify document. Moving this command to after the end tell returns to right result. Sometimes applescript is just strange.