Richard Nagle said: > 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?
It would appear you're into pain. Spaces in column names causes trouble on all fronts. Try Company_Name and Contact_Name and you'll be a lot happier. Or just Company and Contact. Spaces in table names require some variety of quoting or escaping, or they'll be interpretted as separate strings. Clay Dowling -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development