MyDac 4.x : LOCK IN SHARE MODE issue with Master / Details tables.
Posted: Wed 05 Oct 2005 10:13
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) :
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
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 MODEWhen 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