MyDac 4.x : LOCK IN SHARE MODE issue with Master / Details tables.

[swierzbicki]

Dear Support,

I cannot use the mysql 'LOCK IN SHARE MODE' option in Details table when MasterKey and DetailKey are filed

For example, open the Master / Detail Demo bundled with MyDac.
Change the quDetail Master/Detail keys properties to 'DEPTNO'

Change the quDetail SQL property with (I've removed the param as master and detail keys are filed + added a where condition) :

Code: Select all

SELECT * FROM emp
WHERE ENAME  '' 
LOCK IN SHARE MODE

Compile and run.
When opening Detail table, I got an exception :

exception class : EMyError
exception message : #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCK IN SHARE MODE) WHERE DEPNO = 10' at line 3

[Ikar]

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next MyDAC build. It will be available in about one week.
Please look forward for announcments at the forum.