Any help will be greatly appreciated.
Thank you.
I am trying to update a field in an access table using fme_db_operation UPDATE. My workspace seems to work when viewing the results in Inspector but is failing to update the actual table. Not sure what I am missing.
Page 1 / 1
Hi,
What kind of error message has been logged when the translation failed?
Takashi
Format/index/constraint violation maybe?
Hi Takashi and Gio,
The translation does not fail. Its just that the access table is not getting updated. I have set writer mode to UPDATE. Is there anything else I need to look at?
Thanks
Samir
In the "Format Parameters" tab of the writer feature type properties dialog, check if the "SQL Key Columns" parameter has been set properly.
Hi Takashi,
Yes I had put wrong attribute field for "SQL Key Column". It is working now. Thank you for your help.
Samir