I think to do a comprehensive conversion between sqLite syntax and mySQL syntax, I am going to have to do a lot more research. Sad that the differences between all the SQL engine syntaxes are that much. I have a saying that the trouble with standards is that everyone wants one... their OWN.
Bob On Mar 11, 2011, at 10:01 PM, Warren Samples wrote: > On Fri, 2011-03-11 at 21:33 -0800, Bob Sneidar wrote: >> error : 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 '(30), > > Bob, > > Isn't trying to tell you that "datetime(30)" is not a valid declaration? > Should it just be "datetime"? (That's what it looks like from the docs.) > > Best, > > Warren > > > _______________________________________________ > 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