import records only remaining records.

[LVA]

Is there a way to import records, but only the remaining records ?

I have a FM system that pulls out data from a SQL Server database, but as the data are updated on FM in case the record happens to be updated on SQL Server I wouldn't like to update that data on the next impoort. I've tried to use the update radio button on the import window, but if I have to choose a field to be imported.

The SQL Server database table doesn't have a date field so I would like to know if there is a way to import only the new records from SQL Server.

[kennedy]

You haven't given us your definition of "new".

How do you know whether a particular record coming back from SQL Server is new or not?

Depending upon that, you may want to perform a query on SQL Server to only get the new records. Or you may want to set up the import to ignore the old records. Or you may want to import into a temporary FM File where you can do some calcs that determine new-ness, and then import into your final DB from that temporary one.

HTH.

[LVA]

Ok. Sorry.

For example, everyday this import script will be activated so today I am using the script for the first time and I import all the SQL Server records . Tomorrow the script will be activated again and the new records for me will be the ones that haven't been imported today.

The import option in FM has a radiobutton that permits to update the remaining records, but I have to choose at least one field to be imported and that's why this option doesn't work for my case otherwise it would be perfect. Is there something I'm not noticing, that should be done with FM to import only the remaining records ?

I wouldn't like to create another file because this system is already very big with 32 files and that wouldn't be the way out in my case.

I appreciate your help.