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

Outcomes