How to pass data from a FileMaker field to an Applescript

[[email protected]]

I need to delete a file off of my Cincinnati Laser from FileMaker. It gets it there via a FMScript that export field contents of a container to this location. So I know the file name and the path its all built in a calculation field on that record. But I don't know how to get that info into an Applescript using the FM12 "Perform AppleScript" script step

When I hard code the path and file name (Shown Below) it works.

 

"set set xpath to "Titanium Brain:Users:smartin:Desktop:Laser:1512-clr-c.cnc"¶

 tell application "Finder"¶

       delete file xpath¶

 end tell"

 

 

When I try to pass the field contents (Shown Below) it doesn't work.

 

"set xpath to Laser::gCNCPath¶

 tell application "Finder"¶

       delete file xpath¶

 end tell"

 

What am I missing?

[eos]

I'm no AppleScript expert, but I'm sure that the AppleScript engine can't resolve a FileMaker field reference (the same 'problem' as with ExecuteSQL).

 

Try

 

"set xpath to " & Laser::gCNCPath & "¶

 tell application "Finder"¶

       delete file xpath¶

 end tell"