AnsweredAssumed Answered

Alter Financial Type by SQL Script

Question asked by TomConnery on Sep 22, 2009
Latest reply on Sep 24, 2009 by Paul_Maxwell
Hello,   I have a simple select to identify all projects with  Investment Financial Type set to 'Standard'.   What I was hoping to do is write an update script to chaneg these proejcts to 'Internal'.  I wrote the script and can update the table fine, but when I log into Clarity and examine the project properties - financial...   the value is still 'Standard'   ???   Not sure why.   Are there other tables that need to be updated?   Maybe I need more joins...   A lookup association??...  Anyone have an idea?     Select: select i.CODE, i.NAME, p.TYPE_
from niku.inv_investments i, niku.pac_mnt_projects p
where i.ID = p.ID
and p.TYPE_ = 'S'
and i.odf_object_code = 'project'     Update: update niku.pac_mnt_projects
set niku.pac_mnt_projects.TYPE_ = 'I'
from niku.inv_investments i, niku.pac_mnt_projects p
where i.ID = p.ID
and p.TYPE_ = 'S'
and i.code = 'xxxxx'  

Outcomes