[sqlite] Trigger help or how to update id based on column content

[jose i cabrera]

On 2/18/2015 6:48 PM, Igor Tandetnik wrote:
> On 2/18/2015 5:10 PM, jose i cabrera wrote:
>> So, in reality, all the tasks of the project of
>> like "lang" minus the PM, have to be added and 10% of that total be
>> calculated to the (on this instance) DE-DE PM task.
>
> UPDATE LSOpenJobs SET ProjFund =
> (
>        SELECT round(sum(t2.ProjFund) * cast(LSOpenJobs.RateType as 
> integer)/100.0 , 2)
>        FROM LSOpenJobs t2
>        where LSOpenJobs.ProjID=t2.ProjID and LSOpenJobs.lang=t2.lang
>        and t2.PSubClass != 'PM'
> )
> WHERE  PSubClass = 'PM';
>
> This updates all PM projects at once, in the whole table. To be more 
> selective, add conditions in the last WHERE clause to taste.

If I ever meet you, I will buy you lunch. ;-)  Thanks, man.