Quote:
my question now is:
How does this relate to this considering the latter gives an SQL error and the former doesn't |
(Did I ask you what version of OS X you are running ? It begins to feel as if there is a different version of Sqlite running here ...).
On the other hand, the other fields are not ambiguous, so if you can get this slightly modified version to run, you should be fine:
Code:
select \" Available actions\", count(*) from (task t left join context c on t.context=c.persistentIdentifier) where (projectInfo is null) and (t.childrenCount=0) and (dateCompleted is null) and (blocked=0) and (effectiveContainingProjectInfoActive=1) and (blockedByFutureStartDate=0) and ((context is null) or ((allowsNextAction=1) and (active=1)));
Last edited by RobTrew; 2011-03-28 at 02:15 PM.. Reason: adjusted the sqlite code