127 Error Handler

[Amit Jadhav]

At out client site, there is electricitis' fluctuation problem occurs.

SO when they use our software with backend as MySql, and if light is gone then the tables on which they are working can get corrupted and shows error as "127 Error Handler".

After repairing tables programatically, it deletes the data which is lastly inserted.
(In program I simply use repair command)

But if I repair the table from the Mysql/Tool/Table-diagnostics then it shows all the data and cannot delete any record.

So everytime its not possible to visit client and manually repair table.

So is there any way, Using that , if light is gone or due to any reason if table are corrupted , then the data in that tables can remain safe.

I also notice that "Commit" command cannot work. Also I used "Write" command but no effect.
But when we shutdown the server, then data can safely store in database.

So i want when user presses the Save Button then the data has to be saved permanently.(as i use commit in oracle)

So is it better way to use "Write" command after each insert statement ?

Please help me!!