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