[programerboy]

Hi,

I create a trigger like this:

Code: Select all

$db = '9092191375a376e9f2cb0d6057657207';
executeQuery('LOCK TABLES `table1` WRITE, `table2` READ;', $db);
executeQuery('insert into `table1` (`a`, `b`) values("data1", "data2");', $db);
executeQuery('UNLOCK TABLES;', $db);

But don't insert in my table1 and I don't get any errors.
When I execute only insert query it is true.

How can I use lock tables in trigger?

Thanks

[amosbatto]

You are going to have to modify the source code of the executeQuery() function defined in workflow/engine/classes/class.pmFunctions.php to allow it to execute LOCK and UNLOCK commands. I imagine that you can add this code:

Code: Select all

                case preg_match( "/^(LOCK|UNLOCK)\s/i", $statement ):
                    $rs = $con->executeUpdate( $SqlStatement );
                    $result = $con->getUpdateCount();
                    $con->commit();
                    break; 

But I haven't tried it.

[programerboy]

Thank you so much Amos