On 11 Dec 2011, at 10:01am, Account 69 wrote: > Is a column name of "AS" a restricted column name in SQLlite? Can anyone > point me to a webpage that species these restricted column names or is this > an error on my part somewhere
No, you got it right: <http://www.sqlite.org/lang_keywords.html> The word 'AS' is used in commands like this: SELECT (quantity * pricePerItem) AS totalPrice FROM invoiceItems Allowing 'AS' as a column name would make parsing very difficult ! While I'm here, although your table definition will work in SQLite, it might be worth studying up on SQLite3 datatypes so you don't trick yourself into expecting behaviour SQLite doesn't provide. <http://www.sqlite.org/datatype3.html> It might be better to do CREATE TABLE shopdata ( id INTEGER PRIMARY KEY, date_ts INTEGER, H_S REAL DEFAULT 0, A_S REAL DEFAULT 0); You did get 'INTEGER PRIMARY KEY' right, though, which most people don't. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
