topic Re: problem with update in Application Development and Automation Discussions

problem with update

Former Member — Thu, 21 Jun 2007 12:29:33 GMT

Hi,

I have problem with update, why this simple part of program doesn't work?

UPDATE zvratka_prijemky

SET spz = 'test'

WHERE mblnr_101 = '5000084938'

AND zeile_101 = '0001'.

write SY-SUBRC.

sy-subrc returns 4.

thanks.

Re: problem with update

Former Member — Thu, 21 Jun 2007 12:38:31 GMT

Hello,

Are u passing values to all the key feields of the Z table . Check this.


UPDATE zvratka_prijemky
SET spz = 'test'
WHERE mblnr_101 = '5000084938' 
AND zeile_101 = '0001'. 
commit work and wait.  " Check here

Vasanth

Re: problem with update

Former Member — Thu, 21 Jun 2007 12:50:50 GMT

sy-subrc returns 0 but the value still doesn't appear in table.

Re: problem with update

Former Member — Thu, 21 Jun 2007 12:54:42 GMT

Hello,

Always use MODFY statement.

Do like this.

data: wa like zvratka_prijemky.

select single * from zvratka_prijemky into wa where mblnr_101 = '5000084938' 
AND zeile_101 = '0001'.
if sy-subrc = 0.
wa-spz = 'test'.
modify zvratka_prijemky  from wa.
endif.

Hope this solve ur issue.

Vasanth

Re: problem with update

Former Member — Thu, 21 Jun 2007 13:08:02 GMT

Thaks so much, it solves my problem.