Perhaps you mean ...,"a bc_tag" char(254), PRIMARY KEY ("abc_tnam",
"abc_ownr", "abc_cnam") );
-----Ursprüngliche Nachricht-----
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Igor Korot
Gesendet: Dienstag, 22. November 2016 14:46
An: Discussion of SQLite Database <sqlite-users@mailinglists.sqlite.org>;
General Discussion of SQLite Database <sqlite-us...@sqlite.org>
Betreff: [sqlite] CREATE TABLE fails
Hi, ALL,
SQLite version 3.13.0 2016-05-18 10:57:30 Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE IF NOT EXISTS abc("abc_tnam" char(129) NOT NULL,
"abc_tid" integer, "abc_ownr" char(129) NOT NULL, "abc_cnam" char(129) NOT
NULL , "abc_cid" smallint, "abc_labl" char(254), "abc_lpos" smallint, "abc_hdr"
char( 254), "abc_hpos" smallint, "abc_itfy" smallint, "abc_mask" char(31),
"abc_case"
smallint, "abc_hght" smallint, "abc_wdth" smallint, "abc_ptrn" char(31),
"abc_bm ap" char(1), "abc_init" char(254), "abc_cmnt" char(254), "abc_edit"
char(31), "a bc_tag" char(254) PRIMARY KEY "abc_tnam", "abc_ownr", "abc_cnam");
Error: near ""abc_tnam"": syntax error
sqlite>
Where am I wrong?
Also, just out of curiosity - what symbols are allowed in the table/field name?
Is there any restrictions even for "<name>" syntax?
Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___________________________________________
Gunter Hick
Software Engineer
Scientific Games International GmbH
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0
E-Mail: h...@scigames.at
This communication (including any attachments) is intended for the use of the
intended recipient(s) only and may contain information that is confidential,
privileged or legally protected. Any unauthorized use or dissemination of this
communication is strictly prohibited. If you have received this communication
in error, please immediately notify the sender by return e-mail message and
delete all copies of the original communication. Thank you for your cooperation.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
