mySQL chaining queries doesn't work!

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
ckelly5430
Posts: 15
Joined: Wed Sep 11, 2013 3:44 pm

mySQL chaining queries doesn't work!

Post by ckelly5430 » 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

Klaus
Posts: 13829
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: mySQL chaining queries doesn't work!

Post by Klaus » Wed Nov 25, 2015 3:57 pm

Hi Colin,

obviously this is a known inconvenience of revdb:
http://quality.livecode.com/show_bug.cgi?id=10940


Best

Klaus

Post Reply

Return to “Databases”