Hi,
Is there a way to do both operations at the same time? I want it to update the existing ID's and insert the new one in a access database so i can store the data. There is not always an update required , sometimes the existing ID's are not given again.
Thx!
Nathalie
You can set the attribute fme_db_operation to decide if a feature should be updated or inserted when it reaches the writer. In that way you can use tests and the AttributeCreator earlier on in the workspace to define what should happen to the feature in the end.
You can set the attribute fme_db_operation to decide if a feature should be updated or inserted when it reaches the writer. In that way you can use tests and the AttributeCreator earlier on in the workspace to define what should happen to the feature in the end.
I agree. Here's the documentation, which might be helpful: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/DatabaseWriterMode/feature_operations.htm