Good point. The dictionary is kinda confusing on this. It says "do not include a semicolon at the end of the statement", then says "some" sql systems are capable of executing multiple statements, which presumably means terminating each one with a semicolon. I guess it means no semicolon at the end of the last statement.
No idea whether postgres supports multiple statements in one command. Pete lcSQL Software <http://www.lcsql.com> On Thu, May 2, 2013 at 6:27 PM, Mark Wieder <mwie...@ahsoftware.net> wrote: > Richard- > > Thursday, May 2, 2013, 5:33:17 PM, you wrote: > > > I've tried > > BEGIN TRANSACTION; > > CREATE TABLE blah bla blah; > > ALTER TABLE blah OWNER TO dhbk; > > COMMIT; > > Are you trying to put all that into a single sql command? I don't > think you can do that from LC. That is, I don't think the execute sql > statement supports multiple catenated statements. > > -- > -Mark Wieder > mwie...@ahsoftware.net > > > _______________________________________________ > 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 > _______________________________________________ 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