Applescript Filemaker reading field to play quicktime problem

Hello,

New to the forum…(sorry if this is not the right spot for this question)…hoping I can get some newbie question help. I’m pretty sure the problem is to do with the paths and how they are handled…but…obviously I don’t know for sure. I have a filemaker database with a record that has a field in it called:

playbackPath

The value of that field is a unix path to a quicktime movie “/Volumes/UBA_RAID/prod/gen123/gen123.mov”

What I want to do, for many other convoluted reasons, is open the quicktime via applescript. Here is the script that I am using to try and do that…

tell application “FileMaker Pro Advanced”
set realPath to cell “playbackPath” of current record
end tell

set theMovie to (POSIX file realPath)
tell application “QuickTime Player 7”
activate
open file theMovie
end tell

I keep getting a can’t get file error from applescript. I’m sure this is a simple fix to do with POSIX, no? Many thanks for any help,

-Dexterama

Here’s what you can try.

My field value looks like this:
moviemac:/BRADLEY/my-movie-title.mp4

The name of the field is “videopath”

Then the script:

tell application “FileMaker Pro Advanced”
activate
set curMov to get field “videopath” of current record
end tell

set AppleScript’s text item delimiters to {“moviemac:/”}
set myPath to “/Volumes/” & text item 2 of curMov
set AppleScript’s text item delimiters to {“”}

tell application “QuickTime Player 7”
activate
try
open myPath
play document 1
end try
end tell