AnsweredAssumed Answered

ODBC import -- Update matching records issue

Question asked by user29066 on Aug 4, 2017
Latest reply on Aug 7, 2017 by fmpdude

FileMaker 16 (and also tested on 15) 64-bit

Windows 10

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:

Import Mapping.png


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.


Import mapping dialog during script.png


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?


Hedrich Michaelsen

Austin Convention Center