mySQL chaining queries doesn't work!
Posted: Tue Nov 24, 2015 11:45 pm
Anyone know why mySQL chaining queries doesn't work in LiveCode 7.1.1 ?
example :
DELETE FROM t1 WHERE f1 IN ("6888072","6880476");
UPDATE t2 SET f2=NULL WHERE f1 IN ("6888072","6880476");
perfectly valid query using any other mySQL query tool but throws an error in Livecode with invalid syntax.
Regards
Colin
example :
DELETE FROM t1 WHERE f1 IN ("6888072","6880476");
UPDATE t2 SET f2=NULL WHERE f1 IN ("6888072","6880476");
perfectly valid query using any other mySQL query tool but throws an error in Livecode with invalid syntax.
Regards
Colin