EDIT: ha, success!
http://bbs.applescript.net/viewtopic.php?t=4725
guess I did not search hard enough!
thanks to Camelot for the info on doing requests.
/EDIT
if I have a text cell foo in filemaker (5.5 server and client), why does searching for foo starting with “A” return records of foo like “Abracadabra” but also “Wacky Anglophiles” or even “Help A Brother Out” …?! (i.e. not just those starting with A but in fact all records whose cell foo contains space+A somewhere in them…!)
e.g.
property alphaList : {"A", "B", "C", "D"} -- etc.
tell application "FileMaker Pro"
launch
open "bar.fp5"
repeat with alpha in alphaList
show (every record of database 1 whose cell "foo" starts with alpha) -- also tried (alpha as string) for the heck of it, no dice
--do some stuff
end repeat
end tell
thoughts?
thanks!