record locking problems again

jkuiper · Post by **jkuiper** » Thu 11 Dec 2008 17:26

I noticed today that MyDac 570 still has problems with locking.

I'll send you a email with details and samples

Dimon · Post by **Dimon** » Fri 12 Dec 2008 09:42

We have answered you by e-mail.

jkuiper · Post by **jkuiper** » Fri 12 Dec 2008 10:40

I have answered back by email

jkuiper · Post by **jkuiper** » Tue 16 Dec 2008 18:45

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

Thank you Dmitry.

siberya · Post by **siberya** » Sun 28 Dec 2008 01:30

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

Dimon · Post by **Dimon** » Mon 29 Dec 2008 14:34

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.