FMP find every record in list
FMP find every record in list
- Subject: FMP find every record in list
- From: Xandra Lee <email@hidden>
- Date: Tue, 2 Jan 2001 08:22:31 -0500
the following line:
show (every record whose cell "Font ID" is in idList)
-->Fails with error: Cannot handle this object class.
I assume that means it can't handle lists within whose clauses
I ended up with following bit, but would prefer to use the "Show every
record whose... method"
Any ideas for syntax that uses whose clause rather than "create new
request"
------BEGIN SNIPPET-----------
-->>Find every item in a List<<
tell application "FileMaker Pro"
set idList to field "fieldName" as list
--clear the previous find (otherwise users last find will be considered)
go to request 1 --just a way to go to find mode
try
delete every request
on error
end try
repeat with n from 1 to count of items in idList
create new request
set cell "fieldName" of request n to ("==" & (item n of idList) as
string)
end repeat
find
sort window 1 by field "fieldName"
end tell
------------------------
xandra
Alixandra Leigh
AceDesign
email@hidden
------------------------------------------
Furniture:
><
http://home.rochester.rr.com/alexleighs/furniture/furniture.htm>
Renderings:
><
http://home.rochester.rr.com/alexleighs/interiors/interiors.htm>