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.
>
> I suspect SQLite doesn't like column names with two periods. It this it?
>
> Here is my statement:
>
> create table document (TC1.DOCUMENT.SORT TEXT,TC1.DOCUMENT.CLE_CATAL
> TEXT,TC1.DOCUMENT.DORIS_SUBKEY TEXT,TC1.DOCUMENT.DATE_CREAT
> TEXT,TC1.DOCUMENT.LIEN_CATAL TEXT,TC1.DOCUMENT.FICHIER
> TEXT,TC1.DOCUMENT.DATE_MAJ TEXT,TC1.DOCUMENT.DORIS_STAMP
> TEXT,TC1.DOCUMENT.DIRDOC TEXT,TC1.DOCUMENT.UTIL_CREAT
> TEXT,TC1.DOCUMENT.DRAWER TEXT,TC1.DOCUMENT.DORIS_KEY TEXT PRIMARY
> KEY,TC1.DOCUMENT.FOLDER TEXT,TC1.DOCUMENT.CLE_NUMPER TEXT,TC1.DOCUMENT.TYPE
> TEXT,TC1.DOCUMENT.DISPLAY TEXT,TC1.DOCUMENT.CATTABKEY TEXT);
>
enclose column names with double quotes.
[08:23 PM] ~/Sites/pkmap$sqlite3
SQLite version 3.6.11
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE foo (foo.bar.baz TEXT);
SQL error: near ".": syntax error
sqlite> CREATE TABLE foo ("foo.bar.baz" TEXT);
sqlite> INSERT INTO foo ("foo.bar.baz") VALUES ('some stuff');
sqlite> .h on
sqlite> .m col
sqlite> SELECT * FROM foo;
foo.bar.baz
-----------
some stuff
sqlite>
> Thanks,
>
> Jean-Denis
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Puneet Kishor http://www.punkish.org/
Carbon Model http://carbonmodel.org/
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/
Science Commons Fellow, Geospatial Data http://sciencecommons.org
Nelson Institute, UW-Madison http://www.nelson.wisc.edu/
-----------------------------------------------------------------------
collaborate, communicate, compete
=======================================================================
Sent from Madison, WI, United States
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
