Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
sql statement error |
Fri, Mar 3 2006 11:11 AM | Permanent Link |
"Mirco M." | 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! |
Fri, Mar 3 2006 12:42 PM | Permanent Link |
"Halim Boumedjirek" | 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! > |
Fri, Mar 3 2006 3:05 PM | Permanent Link |
Michael Baytalsky | > 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 |
Mon, Mar 6 2006 11:51 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |