Re: [sqlite] CREATE TABLE fails

Hi, guys, Parents with the comma before "PRIMARY" fixed it. Thx. On Tue, Nov 22, 2016 at 9:39 AM, Niall O'Reilly wrote: > On 22 Nov 2016, at 14:35, David Raymond wrote: > >> It's needed. The arrow coming out of [column-def] (visually) goes past >> [table-constraint]

Re: [sqlite] CREATE TABLE fails

O'Reilly Sent: Tuesday, November 22, 2016 9:22 AM To: SQLite mailing list Subject: Re: [sqlite] CREATE TABLE fails I was going to add "missing comma before PRIMARY" as well, but https://www.sqlite.org/lang_createtable.html doesn't seem to indicate that a comma is required betwee

Re: [sqlite] CREATE TABLE fails

On 22 Nov 2016, at 14:35, David Raymond wrote: It's needed. The arrow coming out of [column-def] (visually) goes past [table-constraint] first, with the option to loop down to a comma on its way to a [table-constraint] Thanks. My gut told me one thing, my eyes another. Eyes were wrong.

Re: [sqlite] CREATE TABLE fails

On 22 Nov 2016, at 14:03, Richard Hipp wrote: On 11/22/16, Igor Korot wrote: 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>

Re: [sqlite] CREATE TABLE fails

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

Re: [sqlite] CREATE TABLE fails

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),

Re: [sqlite] CREATE TABLE fails

On 11/22/16, Igor Korot wrote: > 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"

Re: [sqlite] CREATE TABLE fails if SQL starts with comment

Update to version version 3.3.17 has solved the problem. The issue existed in version 3.3.14 - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] CREATE TABLE fails if SQL starts with comment

"Yuriy Martsynovskyy" <[EMAIL PROTECTED]> wrote: > When I execute the SQL code below on a newly created DB file I get an > error 'table Tab already exists', and it creates a table > > -- comment > CREATE TABLE Tab(ID); > > Code below works without error messages: > > CREATE TABLE Tab(ID); > I