On 22/04/2013, at 10:54 AM, Dr. Hawkins <[email protected]> wrote: > I think the following had been working for some time, but now it creates an > error: > > CREATE TABLE plumber_joe_the__001_sofa (uniq_sfky INTEGER PRIMARY KEY , > subq CHAR(3) , a TEXT, b TEXT, c TEXT, d TEXT, ordr INTEGER, user CHAR(20), > tstmp TIMESTAMP WITH TIMEZONE ) > produces > > Error: syntax error at or near "user" at character 135
AFAIK, "USER" is a reserved word in SQL - since SQL-92: http://developer.mimer.com/validator/sql-reserved-words.tml There are some online SQL validators which you may find useful, if you run into issues like this. The site above has 3 validators, which validate your syntax against the SQL standard, rather than trying to validate it against syntax specific to a certain product - ie., MySQL, PostgreSQL, or SQLite. The address for the validators are: SQL-92: http://developer.mimer.com/validator/parser92/index.tml SQL-99: http://developer.mimer.com/validator/parser99/index.tml SQL-2003: http://developer.mimer.com/validator/parser200x/index.tml I hope this helps! -- Igor Couto Sydney, Australia _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
