Question

Updating MS Access table using fme_db_operation

S
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.

 

 

Any help will be greatly appreciated.

 

 

Thank you.

 

 

5 replies

takashi
Rank
Userlevel 2
Badge +17
Hi,

 

 

What kind of error message has been logged when the translation failed?

 

 

Takashi
G
Badge +3
Format/index/constraint violation maybe?
S
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
takashi
Rank
Userlevel 2
Badge +17
In the "Format Parameters" tab of the writer feature type properties dialog, check if the "SQL Key Columns" parameter has been set properly.
S
Hi Takashi,

 

Yes I had put wrong attribute field for "SQL Key Column". It is working now. Thank you for your help.

 

 

Samir

Reply


Community Stats

28,723
Posts
109,511
Replies
36,559
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.