Re: [sqlite] more syntax errors ?

[Witold Czarnecki]

Are there spaces in [Company Name] and [Contact Name] field names?
Regards,
Witold
----- Original Message ----- 
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, February 24, 2005 4:40 PM
Subject: [sqlite] more syntax errors ?


fastmac:/applications/sqlite rn$ ./sqlite contacts
SQLite version 2.8.13
Enter ".help" for instructions
sqlite> Create Table Company (
  ...> Company Name  Character (50)  NOT NULL,
  ...> Contact Name  Character (35),
  ...> Address1      Character (30),
  ...> Address2      Character (30),
  ...> City          Character (30),
  ...> State         Character (2),
  ...> Zip           Character (10),
  ...> Phone1        Character (13),
  ...> Phone2        Character (13),
  ...> Fax           Character (13) ) ;
SQL error: near ".": syntax error
sqlite>
It would appear, the sqlite does not follow the sql rules of syntax ?
or is there something I'm doing wrong?
TKS -
Rick