Four Stars

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.

 

 Capture1.JPGCapture2.JPGCapture3.JPGCapture4.JPGCapture5.JPGCapture6.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: Need help with tmysqloutput component

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

3 REPLIES
Six Stars

Re: Need help with tmysqloutput component

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

Four Stars

Re: Need help with tmysqloutput component

omg. Many thx. I looked everywhere but this ! 

Ten Stars

Re: Need help with tmysqloutput component

are you in auto commit mode?

Francois Denis

Don't forget to tag when it's "solved"!