AnsweredAssumed Answered

Updaing Existing Records via SQL

Question asked by RGoyette on Aug 27, 2010

Title

Updaing Existing Records via SQL

Post

Using FileMaker Pro v 11 on a Windows 7 system and talking to an Oracle server I have previously imported via ODBC a set of records.  Now a few months later I wand to update the set of records I have and import anything new that has been added to the oracle server in the meantime.  I do not want to modify the records that I have already got, or import duplicates.  All combinations I have tried of Update existing records or Update matching records imports duplicates.  The records have a proposal number that can be used as an identifier, so I could say

SELECT * FROM prpsl.EXPT_SMPL
WHERE EXPT_SMPL.PRPSL_ID is not in the set of records I already have if I knew the proper syntax

Can anyone help?

Outcomes