I want to create a Runtime database that will be put on unknown desktop. Have a script to create a copy of the database on closing. I cannot seem to get the file path correct. I have:

SetVariable [$Path;Value:"Filewin:" & Get ( FileMakerPath )& "Backup/" & $BackupName]

Save a Copy as [$Path; compacted]

where the folder "Backup" resides in the runtime folder. $BackupName is set in a previous step and works fin ewhre I set the path 'manually'. I cannot figure out making the Get (FilemakerPath) part to work.

Where am I going wrong?

Also, is there a rather simple way within Filemaker to script the creation of the folder "Backup"?

Edited March 20, 201015 yr by Guest

Use simply "file:Backup/" & $BackupName instead.

Using filewin: means an absolute path starting with C: (or whatever). "file:" is cross-platform and is a relative path starting with the current directory where the datbase file resides. For your purposes, using the "file:" method is much simpler.

Edited March 20, 201015 yr by Guest

Also, is there a rather simple way within Filemaker to script the creation of the folder "Backup"?

No, not within FileMaker.

You can ask a Windows program to do it using the Send DDE Execute, or Send Event script steps, or Go To Field[select/Perform] on a container field with a ref to a windows program/script. Or use a plug-in that provides this capability.

Thanks a lot for the quick and helpful replies.