I just discovered that during the creation of a stand alone FM application using the Developer Utilities all links to external data sources (other FM files) get stripped of their extensions. Thus, if the path used to be:

file:old_data/Address.fp7

it becomes:

file:old_data/Address

Naturally, any script that requires the file Address.fp7 fails.

To me this is a major, extremely serious bug that destroys the functionality of my stand alone solutions. Does anybody know a workaround?

What about using a variable and then a field to hold the file names?

My mind is mush trying to figure out my problem but may not even need the variable....

I believe it's a feature, not a bug. Runtimes are expected to use a different extension, e.g. USR. You can remove the .fp7 extension from all your references to external files, without any ill effects, I think.

See also:

http://fmforums.com/forum/showtopic.php?tid/185105/

http://fmforums.com/forum/showtopic.php?tid/196076/

Yea we just use File and FileTwo as references instead of File.fp7 and FileTwo.fp7, works fine both in client/server and in runtimes then.

I *think* (from memory) when you use FileMaker to add a reference as opposed to typing it, it doesn't add the extension.