I am updating a SQL Server database in FME Desktop 2015. My process runs successfully without error messages but nothing is actually written to the database (the log shows 125 features written). I am using fme_db_operation as the feature operation and the ID field as the match column. I don't know a whole lot about SQL, what am I missing here?
Userlevel 4
- 8177 replies
-
18 January 2017
What is the value of fme_db_operation? If it is INSERT, the feature is always written, but if it is UPDATE or DELETE it will all depend on if the value of the ID field is found in the existing data. If no value of that particular ID is found, nothing happens.
+5
- Contributor
- 30 replies
-
18 January 2017
False alarm, the table is being updated but due to extra rows, it didn't seem like it.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.