Apple Events and Frontier

[Sean Elfstrom]

At 4:47 PM -0500 10/21/02, Nick Cahill wrote:
>I have been having trouble with Frontier passing Apple Events to Filemaker. I'm writing local html files from a Frontier outline, and uploading them to my university web server. Part of the script looks up an image archive number in a Filemaker database. The Frontier export script includes:
>
>with ObjectModel, FileMaker {
>	local (DBRow);
>	result = exists (record[cell[1] == curImage]);
>	if result == false {
>		dialog.alert ("couldn't find " + curImage)};
>	DBRow =  get(record[cell[1] == curImage]);

[snip]

I think you're problem is this part: "record[cell[1] == curImage]". It has been my experience that FileMaker doesn't properly handle "whose clauses" (AppleScript term for what you're trying to do) in Mac OS X. I had to rewrite a lot of my scripts to use FileMaker find requests to avoid this problem.
-- 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Sean Elfstrom      selfstro at ImagiQ.com | ImagiQ    http://www.ImagiQ.com/
XO/Mac Wrangler         PGP:0x716F29D6 | 2325 NW Military, Suite 103
Apple Product Professional          O- | San Antonio, TX 78231
Apple Specialist                       | 210-377-3545        800-750-0787