AnsweredAssumed Answered

Insert File script step does not close directory handle on Windows

Question asked by Ian Harris on Aug 2, 2018
Latest reply on Aug 3, 2018 by Ian Harris

Product and version: FileMaker Pro Advanced 16.0.4.403 and FileMaker Pro Advanced 17.0.1.143

 

OS and version: Various Windows PC operating systems, and Windows Server 2012R2 Standard.

 

Hardware: Varies.

 

Description: After inserting a file into a container field via the Insert File script step, the file's parent directory cannot be modified until the user quits FileMaker. Windows displays a "Folder In Use" dialogue if the user attempts to modify the parent directory while FileMaker is still open. Searching for the directory's name within Resource Monitor's Associated Handles section reveals that FileMaker Pro Advanced.exe leaves a directory handle open after completing the Insert File script step.

 

How to replicate:

  1. Create a container field. Mine is configured to store data externally, though I'm not sure it matters.
  2. Put the container field on a layout. Create a button on the layout that performs the Insert File script step with the following options: Screen Shot 2018-08-02 at 9.50.00 AM.png
  3. Create a folder on your desktop. Place an image file in the folder.
  4. Insert the image file into the container field using the button you created in step two.
  5. With FileMaker still open, attempt to rename the folder on your desktop. You should receive a "Folder In Use" warning from Windows.
  6. Close FileMaker. You should now be able to rename the folder.

 

Workaround: Dragging and dropping a file into the container field allows the file's parent directory to be modified.

Outcomes