I've a need to execute a batch file from within FileMaker Pro 9. using 'Send Event' method I'm able to do this. However facing some issues in specifying the file path for the .bat file.

For example I need to dynamically create the batch file and execute it.

I'm attaching a sample project which explains my needs.

The catalog I create (sample) contains two fields.

ID, Path. ID is autogenerated number. Path is a calculation field which will hold DOS command to create folder.

I have a script which will export the DOS commands (the contents of the Path field) to a btach file. then I need to execute the batch file.

Please note that there already exists a folder named 'Pictures' in parallel to the database catalog. So I've written the script in such a way that the batch file will be created under this folder.

This is working well. However I want the folders to be created by executing the batch file (the folders will be created in parallel where the batch file resides)

Using the 'Send Event' command if I explicily point the location of the bat file it works fine and creates the folders. However if I try to copy this catalog and 'Pictures' folder in another directory I don't see any folders created. However I can see the batch file getting created.

(if what I've explained is confusing please have a look at the attached zip file)

looking forward to your replies.........

BatDemo.zip

I am dealing with a similar problem, but your demo has given me an idea.

1. Set the value of a text field to be the complete contents of the batch file.

2. Then, set the filename of the batch file using this Variable Filenames

I hope that helps,

Bill D.

One additional item, each line in the batch file needs to be a separate record.

Edited June 5, 200817 yr by Guest
Missed a step