hopefully this should be easy ..

i have database that plays a soundfile via quicktime using a script which basically uses a field as the filepath. now all i want to do is write a script which shows that file in the finder ,basically a "reveal file" function .

any ideas

thanks

paul apted

tell application "Finder"

activate

reveal myfilepath

end tell

---

FYI - I was going to ask how to handle the quote and then I came up with this. Note 'qut' is a global field with one straight quote in it. And the substitute function to help keep it clean. Also I found that quotes are required around the path (osX).

Substitute(

"tell application ^Finder^

activate

reveal ^" & SourcePath & "^

end tell",

"^", qut)

You don't really need to worry about handling the quote. I normally put the whole applescript (quotes and all) into a global field (gScriptCode) in this kind of "merge field" format:

tell application "Finder"