topic Re: update a value in table. in Application Development and Automation Discussions

update a value in table.

Former Member — Wed, 16 Apr 2008 16:19:56 GMT

Hi Gurus,

I needed to write a small program to update the value of TVARV-LOW to F, programatically. for the already existing entries of TVARV where type = P, numb = 0001, sign = I, and option = EQ.

Can you please help..

Rgds

Re: update a value in table.

Former Member — Wed, 16 Apr 2008 16:31:33 GMT

Hi,

You can do as below:


UPDATE TVARV SET   low = 'F' 
               WHERE type  = 'P'   AND 
                     numb = '0001' AND 
                     sign = 'I' and 
                   option = 'EQ'.

Thanks,

Sriram Ponna.

Re: update a value in table.

Former Member — Wed, 16 Apr 2008 16:45:20 GMT

Thanks a lot... it helped.