Skip to main content
Question

Update/insert acces writer

  • December 13, 2019
  • 2 replies
  • 86 views

nath
Contributor
Forum|alt.badge.img+6
  • Contributor

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

 

2 replies

Forum|alt.badge.img
  • December 13, 2019

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.


david_r
Celebrity
  • December 13, 2019
danullen wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings