AnsweredAssumed Answered

Insert file error does not produce an error code

Question asked by CraftICT on Nov 6, 2013
Latest reply on May 9, 2017 by TSGal

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.

Outcomes