in 4.20 version i use this statement:

CREATE TABLE IF NOT EXISTS prova (
idx AUTOINC,
transp INTEGER,
data TIMESTAMP
PRIMARY KEY (idx) COMPRESS NONE )


In 4.22 version i receive an error at line 4
If i put a comma at the end of line all work fine.
Is this normal?

thanks!

I remember having this issue too.

"Mirco M." <m.malagoli@matx.it> wrote in message
news:404BDCB0-6FD3-4B19-B80C-6F8307273F11@news.elevatesoft.com...
> in 4.20 version i use this statement:
>
> CREATE TABLE IF NOT EXISTS prova (
> idx AUTOINC,
> transp INTEGER,
> data TIMESTAMP
> PRIMARY KEY (idx) COMPRESS NONE )
>
>
> In 4.22 version i receive an error at line 4
> If i put a comma at the end of line all work fine.
> Is this normal?
>
> thanks!
>

> In 4.22 version i receive an error at line 4
> If i put a comma at the end of line all work fine.
> Is this normal?
IMO, yes, this is what the manual says (or at least this is
how I read it and this is what seem natural as far as
syntax concerned.


Michael

Mirco,

<< in 4.20 version i use this statement:

CREATE TABLE IF NOT EXISTS prova (
idx AUTOINC,
transp INTEGER,
data TIMESTAMP
PRIMARY KEY (idx) COMPRESS NONE )

In 4.22 version i receive an error at line 4 If i put a comma at the end of
line all work fine. Is this normal? >>

Yes.  In fact 4.20 and earlier were incorrect and should have raised an
error without the comma.  Constraints must be added just like a column with
a comma separating them from other columns/constraints.

--
Tim Young
Elevate Software
www.elevatesoft.com