I've just been messing with things with the on-rev mysql server. It doesn't seem like you can pass a whole multiline with 1 revexecutesql
If you do: revexecutesql connectid,"START TRANSCTION" revexecutesql connectid,"ALTER TABLE dna ADD disp BOOLEAN" revexecutesql connectid, "ALTER TABLE dna ADD cont CHAR(1)" revexecutesql connectid, "ALTER TABLE dna ADD coDbt CHAR(1)" revexecutesql connectid,"COMMIT" The error will most likely go away. And you still get the speed benefit of using a single transaction for multiple alters. > I've fired up again, and now, with a command of > BEGIN > ALTER TABLE dna ADD disp BOOLEAN > ALTER TABLE dna ADD cont CHAR(1) > ALTER TABLE dna ADD coDbt CHAR(1) > COMMIT > > > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
