SQLite Forum

create taable with syntax error works ?
this statement "works" bt create the table with what appears to be columns missing (but the raw text of the create statement is identical)

NOTE there is a missing comma between "ProjectDescription String" and "ProjectStartDate"

Seems to me this should raise some kind of error

create table if not exists IDE_Projects( 
id Integer PRIMARY KEY Not NULL, 
ProjectName String Not NULL,  
ProjectDescription String  
ProjectStartDate DATE Not NULL