script works outside fm no go in calc field?

[lance123]

Hi To All,

I am using Indesign CS2 and Incatalog to dynamically update data from Filemaker. This all works fine. (Incatalog is a plugin for Indesign and works well)

I am having trouble with an applescript that will work no problems from the editor. When I run it from within a calc field in FM 8 it seems to go into an endless loop. I then have to force quit Indesign CS2.

Here are the two scripts that I want to run sequentially. The status is that both the fm DB and the Indesign target are open the second script fails in an endless loop.

tell application "Adobe InDesign CS2"

activate

tell application "Finder"

open file "Macintosh HD:Users:path:Indesign ODBC Incatalog link:Test DB ODBC.indd"

end tell

end tell

[color:red]then the bit that fails when in FM

tell application "Adobe InDesign CS2"

update document using FileMaker "Macintosh HD:Applications:Adobe InDesign CS:Test DD Set.txt"

end tell

It says "connection attempt failed"

Any help much appreciated.

Regards,

Lance

Edited March 19, 2006 by Guest