SQLite Forum

create taable with syntax error works ?
Login
It creates the table with no errtor and the last column doesnt exist

the affinity doesnt seem to be the problem


```
create table if not exists IDE_Projects( 
  id INTEGER PRIMARY KEY NOT NULL, 
 ProjectName TEXT not null, 
  ProjectDescription text
  ProjectStartDate text not null 
 ) ;
```
but still the table is created - without complaint - but the column doesnt exist

```
insert into IDE_Projects( id, projectname, projectdescription, projectstartdate ) values ( 1, 'foo' , 'bar' , null ) ;
```

Error: table IDE_Projects has no column named projectstartdate