10 Replies Latest reply on May 9, 2017 6:26 AM by TSGal

    Insert file error does not produce an error code

    CraftICT

      Summary

      Insert file error does not produce an error code

      Product

      FileMaker Pro

      Version

      v12.0v5 (Mac)  and v12.0v4 (Win)

      Operating system version

      Mac O X 10.8.5 and Windows 7

      Description of the issue

      When using the 'Insert File' command, in this case inserting a Microsoft Word file into a container field, and the file is still open in Word a FileMaker Pro message appears "This file is locked or in use". However, the "Last Error' returns zero, therefore despite using 'Set Error Capture On' the error cannot be trapped for in a script.

      This may be the opposite to a previous posting relating to suppressing error codes when exporting (can't find the original, but an appended -http://forums.filemaker.com/posts/9a65908bec - report was posted in 2010(!). If this is the case, then this appears to have been outstanding from at least version 8

      Steps to reproduce the problem

      Open a Microsoft Word file then use the script step 'Insert File' to add this file into a FileMaker container field

      Expected result

      As a 'FileMaker Pro' message reports 'This file is locked or in use' we would expect the 'Last Error' to be greater than zero.

      Actual result

      The 'Last Error' remains at 0

      Exact text of any error message(s) that appear

      This file is locked or in use.

      Configuration information

      Tested on both Mac and Windows in the latest versions of FileMaker Pro Advanced v12. However, believe this may be related to a similar post that dates back to more than 3 years.

      Workaround

      None that we can find. Unfortunately as we cannot trap for the error scripts continue to run and results in inaccurate information in the database.