Hi!

 

I have a file with 'Check OUT' and 'Check In' functionality.

I 'Check Out' a file from a container field to temp storage using 'Export Field Content' and 'Check In' from the same location(temp storage) using 'Insert File' after making changes.

If I Check Out an Excel or Word file, and try to 'Check In' while the 'Checked Out' file is still open, I get the error 'This file is locked or in use.' (please refer screenshot) but the script does not throw any FileMaker error.(It works fine with Text file)

How can I capture the error if file is open and FileMaker can not perform 'Insert File'? ( So that I can avoid setting flag fields)

 

I am using Windows 7 and FM Pro Advance 12.

I have attached a sample file.

 

Thank you.

 

sample check out.zip

I don't think you can supress that error... not sure if that is a bug or not.

 

But something else: your check-out uses the get(temporarypath) folder.  Keep in mind that this path is generated for the duration of the script and that FM will attempt to delete that folder when the script ends... you should not expect that folder to be there for your "check in".  Read up on what is in the help file for get(temporaryPath)

In my experience FM deletes items in the Temporary Path folder when quitting the application.