[sqlite] Create Table Issue.?

[Rao, Prasanna [EPM/RTC]]

--Drop table SPMBLOCK;

CREATE TABLE [SPMBlock] (
        [SPMId] [int] identity(1,1) NOT NULL ,
         [DeviceId]   char  (3) ,
         [SPMIndex]   char  (3) ,
         [SPMStatus]   char  (4) ,
         [BaselineMean]   char  (10) DEFAULT (0),
         [Mean]   char  (10) DEFAULT (0),
         [BaselineStdDev]   char  (10) DEFAULT (0),
         [StdDev]   char  (10) DEFAULT (0)
) ;

Sqlite gives error msg 'near "(":syntax error'

I have not been able to figure out issuse with statement.

Any help appreciated.


Prao.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]