Setting status colors

[Aleksandar]

Hi,

I am trying to set the status colors through the automation interface. Since there are no methods for it, I'm using a sql querry to add a new status, in the t_statustypes table..which works perfectly fine.
However I'm unable to set the colors in the t_genopt table...  

sql = "UPDATE t_genopt SET Option='sName=On-going,sColor=128;sName=Rejected,sColor=32768;sName=Under Review,sColor=12639424;', AppliesTo='Status' WHERE AppliesTo='Status'";
               repositoryEA.Execute(sql);

Is the problem maybe that the Option field in     t_genopt is type MEMO, so it should be accessed differently?

Thank you,

[KP]

Option may be a keyword in whatever database you are using. Try putting it inside square brackets

Code: [Select]

UPDATE t_genopt SET [Option]=...

[Stefan Bolleininger]

Hi Aleksandar,

I don't know so much about the correct sql syntax, but my working query is

Code: [Select]

sql = "UPDATE t_genopt SET Option='sName=On-going,sColor=128;sName=Rejected,sColor=32768;sName=Under Review,sColor=12639424' WHERE AppliesTo='Status'";
Regards

Stefan

[Aleksandar]

Hi,


sql = "UPDATE t_genopt SET [Option]='sName=On-going,sColor=128;sName=Rejected,sColor=32768;sName=Under Review,sColor=12639424' WHERE AppliesTo='Status'";


Now it works fine. Thanks for the help