Devart Forums

I noticed today that MyDac 570 still has problems with locking.
I'll send you a email with details and samples

We have answered you by e-mail.

I have answered back by email

Problem solved. Before locking the record, call refreshrecord first.

Thank you Dmitry.

is it possible ?

CREATE TABLE `test` (
`ID` int(11) unsigned NOT NULL auto_increment,
`MYTIME` time default NULL,
PRIMARY KEY (`FIS_ID`),
) ENGINE=InnoDB;

INSERT INTO `test` (`ID`, `MYTIME`) VALUES
(1, '02:58:52');

First RefreshRecord no error and Record Lock command

"Record was changed by another user"

This error message only mytime field value is 02:58:52

This problem can appear only if you assign a value of a time field with datetime functions like Time(), but not as a string value.
We have fixed this problem . This fix will be included in the next MyDAC build.