Reconnecting the MySql server reposts the last command

[starhu]

Hello,

The scenario is this:
-my program uses MyDac to connect MySql server
-sometimes (1-3 times a day) the connection is lost
-the program reconnects automatically (at onConnectionLost)
-at this moment the last executed command is repeated on the server.

Because almost all commands are Insert-s this provides a great problem e.g. an invoice row is duplicated.

How can I prevent this?

Thank you.

[ViktorV]

To solve the issue, you can set the RetryMode variable to rmReconnect, but not to rmReconnectExecute.

[starhu]

Thank you very much!

[ViktorV]

Thank you for your interest to our product.
Thank you for the feedback and interest to our product.