Any help will be greatly appreciated.
Thank you.
Question
Updating MS Access table using fme_db_operation
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.
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.
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.
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
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.