FileMaker 16 (and also tested on 15) 64-bit
ODBC Driver 13 for SQL Server version 2015.131.4413.46
I am attempting to set up a script which will update matching records in a table in FileMaker from a SQL Server data source. The FileMaker table contains already 1000+ records.
In the ODBC import script step, I can set the mapping to do the import on matching records, with PIDM as the match key as below:
However, when I run the script I get error #409.
If I modify the script to show the import dialog during execution, I note that the PIDM field mapping no longer has the "=", indicating to match the records on this field.
During script execution, I can simply change it back to "=" and the matching records update works as expected. I just can't seem to get it to work without my intervention during the script. After the script has run and I inspect the script the "=" is indeed there, as before. Any suggestions?
Austin Convention Center