On Thu, May 2, 2013 at 7:14 PM, Peter Haworth <p...@lcsql.com> wrote: > 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.
Thinking of how psql does it, it must be appending a semicolon--but an extra semicolon should be harmless, as well. > No idea whether postgres supports multiple statements in one command. The BEGIN/COMMIT is most definitely supported in postgres (and I think even sqlite has rudimentary support for it) -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ 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
