On Sun, Apr 21, 2013 at 9:18 PM, Igor de Oliveira Couto <i...@semperuna.com> wrote: > On 22/04/2013, at 10:54 AM, Dr. Hawkins <doch...@gmail.com> 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
*d'oh* ! The possibility occurred to me later. SQLite was perfectly happy with that column . . . > 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: Thank you! I need the sqlite for the local cache & synchronization; offsite lag is just too much sometimes. But that also means silly arrays for the write values of booleans, and a few other quirks. *sigh* > I hope this helps! Very much so. I'm trying to keep it speaking postgres, sqlite, and mysql (in about that order)--I guess the standard should be there two (but pages and pages of, "this is the part of the standard we ignore . . .) -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ 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