"Rao, Prasanna [EPM/RTC]" <[EMAIL PROTECTED]> writes:
> --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.
sqlite does not like to have the DEFAULT values parenthesized. This works:
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
) ;
Derrell
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
