Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need help with tmysqloutput component

Hi everyone, 
I have an issue with the tmysqloutput component while trying to perform an update on my table.
No errors appears but no upate are done (unfair).
I tried my best but now I'm calling for a little help from the community.
So if someone could have a look to my problem...
Now the rock :
I have a "bpsupplier" table with many fields. I only want to update a date field.
The script run well without any error, but I don't understand why the update isn't done in the MySQL database.

 

 0683p000009Ly3j.jpg0683p000009Lxui.jpg0683p000009Lxzx.jpg0683p000009Ly3y.jpg0683p000009Ly48.jpg0683p000009Ly4N.jpg

Labels (3)
1 Solution

Accepted Solutions
navds
Creator II
Creator II

Have you forgotten to check "Auto Commit" in advanced settings of your tMysqlConnection ?

View solution in original post

3 Replies
navds
Creator II
Creator II

Have you forgotten to check "Auto Commit" in advanced settings of your tMysqlConnection ?

Anonymous
Not applicable
Author

omg. Many thx. I looked everywhere but this ! 

fdenis
Master
Master

are you in auto commit mode?