FM Techinfo confirms the problem -- when use Open URL, the URL that gets passed to Safari or Internet Explorer is made all lower case. Unfortunately, the site that I am connecting to requires that part of the URL be upper case. This might be a Mac-only problem, I'm not sure.

This use to work fine in FM Pro 6 (i.e., the upper case characters were preserved), but is broken in FM Pro 7. Does anyone know of a work-around?

Thanks

It seems that AppleScript retains the case. Try this is Script Editor (remove the tell "FileMaker", end tell, lines when run in a Perform AppleScript step):

tell application "FileMaker Pro"

tell current record of document 1

set theURL to cell "theURL"

end tell

end tell

tell application "Safari"

activate

set the URL of document 1 to theURL

end tell

It should be possible to use the default browser with the following line instead of the tell "Safari" block. It works from Script Editor, but not within FileMaker:

tell application "FileMaker Pro"

tell current record of document 1

set theURL to cell "theURL"

end tell

end tell

open location theURL

I get a "wrong data type" error.?

GetURL7.zip

A clever lad has found a way to trick FileMaker into using "open location." Finder also gets an error, but this doesn't:

tell application "loginwindow" to open location

Don't know what difference it makes. But good to know, I guess.