Assuming mySQL will accept multiple statements, I believe Livecode wants you to omit the semicolon statements at the end of each line.
Your START and COMMIT statements are superfluous in this case since SQL automatically wraps single statements in a transaction so I'd remove them and avoid whatever issue is causing the multi-line problem. Pete lcSQL Software <http://www.lcsql.com> On Sat, Aug 18, 2012 at 10:13 AM, Dr. Hawkins <doch...@gmail.com> wrote: > My code is designed to update the database automatically when new items are > added to cards. This was working fine with sqlite, although it was > apparently ignoring some ' that shouldn't have been there. > > I'm even trying to group transactions now. > > However, > > START TRANSACTION; > ALTER TABLE dna ADD chrType CHAR(1); > COMMIT; > > This, though, produces the error > > revdberr,You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use near > 'ALTER TABLE dna ADD chrType CHAR(1); > COMMIT' at line 2 > > It's not that there is already such a variable: > > put revDatabaseColumnNames(getDebtordb(),"dna") > yields > uniqDna,dnaKey > > The documentation pages seem to show the same syntax > athttp://dev.mysql.com/doc/refman/5.1/en/alter-table-examples.html > : > > ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20); > > ALTER TABLE t2 ADD d TIMESTAMP; > > > I must be missing something trivial at this point. > > -- > The Hawkins Law Firm > Richard E. Hawkins, Esq. > (702) 508-8462 > hawkinslawf...@gmail.com > 3025 S. Maryland Parkway > Suite A > Las Vegas, NV 89109 > _______________________________________________ > 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
