Insert file error does not produce an error code
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
As a 'FileMaker Pro' message reports 'This file is locked or in use' we would expect the 'Last Error' to be greater than zero.
The 'Last Error' remains at 0
Exact text of any error message(s) that appear
This file is locked or in use.
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.
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.