9 Replies Latest reply on Aug 7, 2017 1:27 PM by fmpdude

    ODBC import -- Update matching records issue


      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