On Wed, Feb 22, 2012 at 11:14 PM, Petite Abeille
petite.abei...@gmail.comwrote:
http://www.sqlite.org/lang_keywords.html
@sqlite3 committers: there's a minor error on that page: is says There are
three ways of quoting... and then goes on to show four ways.
--
- stephan beal
I seem to have stumbled upon what looks like a bug in SQLite. I
accidentally created a column in a table that included a space in its
name,eg Col 1. The CREATE TABLE command accepted without an error but if
I try to access that column in any way, I get an error, no matter whether I
specify the
On Wed, Feb 22, 2012 at 10:21 PM, Pete p...@mollysrevenge.com wrote:
I seem to have stumbled upon what looks like a bug in SQLite. I
accidentally created a column in a table that included a space in its
name,eg Col 1. The CREATE TABLE command accepted without an error but if
I try to access
On 2/22/2012 4:21 PM, Pete wrote:
I seem to have stumbled upon what looks like a bug in SQLite. I
accidentally created a column in a table that included a space in its
name,eg Col 1. The CREATE TABLE command accepted without an error but if
I try to access that column in any way, I get an
For example if I SELECT Col 1 FROM... I get a syntax error near 1
(which I'd expect). If I try 'SELECT CoL 1 FROM..., I get and error no
such column Col1 - notice there is no space in the column name listed in
the error message.
Are you escaping the quotes for whatever language / tool you
On Feb 22, 2012, at 10:21 PM, Pete wrote:
I try to access that column in any way, I get an error, no matter whether I
specify the column name with no quotes, single quotes or double quotes
For the record:
http://www.sqlite.org/lang_keywords.html