AnsweredAssumed Answered

Import Script Step

Question asked by user22756 on Jun 22, 2014
Latest reply on Jun 24, 2014 by wimdecorte

I want to sync a FM table ('A') with a MySQL table ('B') by using a script.


Table Occ. A has primary key 'recordid'.

Table Occ. B has primary key 'id' and also stores 'recordid' as a INT field.


This is what my script looks like (translated from Dutch)

Freeze Window
Go To Layout ["_A" (A)]
Execute Search
Import Records ["myDb.fmp12"; Adjust Matching Records ;Mac Roman]
Go To Layout [original layout]


I compare my two TO's based upon 'recordid', since that is matching in both tables.

For some reason, I always get a new record in my MySQL table.


What am I missing here??