remedial mysql???

[Peter Haworth]

You don't HAVE to remove the START/COMMIT, I was pointing out that they are
superfluous.  Leave them in if you wish.

The semicolon issue has nothing to do with what mySQL requires, it's a
Livecode requirement - see the dictionary.

Finally, if you're using revDataFromQuery to do this, I'm surprised it ever
worked.  You're not getting data from a query, you're executing SQL
commands so you need to use revExecuteSQL.

Pete
lcSQL Software <http://www.lcsql.com>



On Sat, Aug 18, 2012 at 11:05 AM, Dr. Hawkins <dochawk at gmail.com> wrote:

> MySQL explicitly supports the semicolons, the multi-line, and the
> START/COMMIT syntax.
>
> I have to remove *all* of these to get revDataFromQuery to work . . .
>
> This seems a bit . . . odd . . .
>