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??

Outcomes