Skip to main content
Question

Update/insert acces writer

  • December 13, 2019
  • 2 replies
  • 89 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

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

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