What's wrong with this <sql> picture?

[Bob Sneidar]

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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode