[sqlite] Syntax for column names?

2009-04-28 Thread Jean-Denis Muys
Hello, My create table statement (program-generated from a text file) below yields a syntax error. I went to SQL syntax diagrams, and as far as I could see, the table-name box is not detailed in its own diagram. I suspect SQLite doesn't like column names with two periods. It this it? Here is

Re: [sqlite] Syntax for column names?

2009-04-28 Thread P Kishor
On Tue, Apr 28, 2009 at 10:03 AM, Jean-Denis Muys jdm...@kleegroup.com wrote: Hello, My create table statement (program-generated from a text file) below yields a syntax error. I went to SQL syntax diagrams, and as far as I could see, the table-name box is not detailed in its own diagram.

Re: [sqlite] Syntax for column names?

2009-04-28 Thread Igor Tandetnik
Jean-Denis Muys jdm...@kleegroup.com wrote: My create table statement (program-generated from a text file) below yields a syntax error. Column names should be valid identifiers (a sequence of digits, letters and underscores that doesn't begin with a digit), or else enclosed in double quotes,

Re: [sqlite] Syntax for column names?

2009-04-28 Thread D. Richard Hipp
On Apr 28, 2009, at 11:38 AM, Igor Tandetnik wrote: Jean-Denis Muys jdm...@kleegroup.com wrote: My create table statement (program-generated from a text file) below yields a syntax error. Column names should be valid identifiers (a sequence of digits, letters and underscores that