Re: [sqlite] Syntax Error For 3.0.8 --> 3.2.1 Upgrade

2005-04-21 Thread William Hachfeld
On Thu, Apr 21, 2005 at 11:57:19AM -0700, Darren Duncan wrote: > One of your problems is that you are using single quotes for a delimited > identifier, "Open|SpeedShop", when you should be using double quotes. > > Single quotes means a string literal in the SQL standard, where double quotes > a

Re: [sqlite] Syntax Error For 3.0.8 --> 3.2.1 Upgrade

2005-04-21 Thread Darren Duncan
At 12:07 PM -0500 4/21/05, William Hachfeld wrote: sqlite> CREATE TABLE 'Open|SpeedShop' (version INTEGER); sqlite> INSERT INTO 'Open|SpeedShop' (version) VALUES (1); One of your problems is that you are using single quotes for a delimited identifier, "Open|SpeedShop", when you should be using

Re: [sqlite] Syntax Error For 3.0.8 --> 3.2.1 Upgrade

2005-04-21 Thread D. Richard Hipp
On Thu, 2005-04-21 at 12:07 -0500, William Hachfeld wrote: > Heh everyone! > > I've recently tried to upgrade from SQLite 3.0.8 to 3.2.1 and have run into a > snag. This is probably something REAL simple that I'm just not seeing. I'm > hoping someone can point out my stupid mistake... > COLUMN

Re: [sqlite] Syntax Error For 3.0.8 --> 3.2.1 Upgrade

2005-04-21 Thread William Hachfeld
Quite right Thomas and Jolan! I knew it was going to be something stupid on my part. If I change the field "column" to "clumn" it works just fine. Thanks! -- William Hachfeld

Re: [sqlite] Syntax Error For 3.0.8 --> 3.2.1 Upgrade

2005-04-21 Thread Jolan Luff
On Thu, Apr 21, 2005 at 12:07:24PM -0500, William Hachfeld wrote: > I've recently tried to upgrade from SQLite 3.0.8 to 3.2.1 and have run into a > snag. This is probably something REAL simple that I'm just not seeing. I'm > hoping someone can point out my stupid mistake... > > When I rebuild our

RE: [sqlite] Syntax Error For 3.0.8 --> 3.2.1 Upgrade

2005-04-21 Thread Thomas Briggs
:07 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Syntax Error For 3.0.8 --> 3.2.1 Upgrade > > > Heh everyone! > > I've recently tried to upgrade from SQLite 3.0.8 to 3.2.1 and > have run into a > snag. This is probably something REAL simple that I'm just &g

[sqlite] Syntax Error For 3.0.8 --> 3.2.1 Upgrade

2005-04-21 Thread William Hachfeld
Heh everyone! I've recently tried to upgrade from SQLite 3.0.8 to 3.2.1 and have run into a snag. This is probably something REAL simple that I'm just not seeing. I'm hoping someone can point out my stupid mistake... When I rebuild our project with 3.2.1 instead of 3.0.8, I'm getting a syntax