Update statement not working

[Former Member]

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]

Hi Venkat,

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

regards,

Anoop Panackal

[Former Member]

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]

Hello ,

Better to use Modify Ztable instead of Upload.

[Former Member]

Hi Venkat,

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

regards,

Anoop Panackal