topic Re: Update statement not working in Application Development and Automation Discussions

Update statement not working

Former Member — Thu, 16 Oct 2008 08:07:04 GMT

Hi,

I created ztable with fields mandt,name(primary key) and value and created one record with name = 'cash' and value = 0.

but when i am using

UPDATE ZCASH SET VALUE = V_CLOSE WHERE NAME = 'CASH'.

in the program the 'v_close' value is not getting updated in zcash.Please suggest where i am going wrong.

Thanks,

Venkat.

Former Member — Thu, 16 Oct 2008 08:12:18 GMT

Hi,

Check the value of V_CLOSE is a non-zero value.

Check whether there exists a record in ZCASH with NAME = 'CASH'.

Add COMMIT WORK after update.

Best regards,

Prashant

Former Member — Thu, 16 Oct 2008 08:13:01 GMT

Hello ,

Better to use Modify Ztable instead of Upload.

Former Member — Thu, 16 Oct 2008 08:16:44 GMT

Hi Venkat,

Your update statement is correct. just check if there is some issue with 'CASH' and 'cash'.

regards,

Anoop Panackal