There is a problem in the first group of SQL statements. The coffee hadn't set in, and I always find crap on a reread-after-submission. Should read as follows:
Previously: create table Tasks (TaskID INTEGER PRIMARY KEY AUTOINCREMENT, fkProjectID integer, TaskID integer, TaskName char, Completed Bool, DateCompleted DateTime); Working: create table Tasks (TaskID INTEGER PRIMARY KEY AUTOINCREMENT, fkProjectID integer, TaskName char, Completed Bool, DateCompleted DateTime); I had put two field TaskIDs in. Told ya the compiler was buggy. :] Old: create view IncompleteTasks as select ProjectID, ProjectName, TaskID, TaskName from Projects join Tasks on Projects.ProjectID=Tasks. fkProjectID; create view CompletedTasks as select ProjectID, ProjectName, TaskID, TaskName, DateCompleted from Projects join Tasks on Projects.Project=Tasks.fkProjectID; New: create view IncompleteTasks as select ProjectID, ProjectName, TaskID, TaskName from Projects join Tasks on Projects.ProjectID=Tasks. fkProjectID where isnull(Completed) or Completed=0; create view CompletedTasks as select ProjectID, ProjectName, TaskID, TaskName, DateCompleted from Projects join Tasks on Projects.Project=Tasks.fkProjectID where !IsNull(Completed) or Completed !=0; I use [ Completed != 0 ] as some software defines TRUE as 1 while others define TRUE as -1. On Thu, Jan 30, 2014 at 10:53 AM, jose isaias cabrera <cabr...@wrc.xerox.com > wrote: > > Wow! thanks for this. I have to read it slowly to capture the > understanding of some of the syntax. But this is great! thanks. > > Stephen Chrzanowski" wrote... > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
