topic Re: UPDATE in Application Development and Automation Discussions

UPDATE

Former Member — Fri, 28 Dec 2007 10:27:40 GMT

is this code correct or do i need to put the table name befror the field name

UPDATE NRIV SET NRRANGENR = number where OBJECT = 'J_1IEXCLOC'

or it should be

UPDATE NRIV SET NRIV-NRRANGENR = number where NRIV-OBJECT = 'J_1IEXCLOC'

Re: UPDATE

Former Member — Fri, 28 Dec 2007 10:30:50 GMT

it should be

UPDATE NRIV SET NRRANGENR = number where OBJECT = 'J_1IEXCLOC'

Re: UPDATE

Former Member — Fri, 28 Dec 2007 10:33:09 GMT

first one is ok

plzz reward if u found i am helpfull.. plzz

Re: UPDATE

Former Member — Fri, 28 Dec 2007 10:33:54 GMT

Thats a danger comand to be used in NRIV or other standard table... Use transaction SNRO to manipulate the NRIV table or the functions in function group SNR3.

Re: UPDATE

Former Member — Fri, 28 Dec 2007 11:12:08 GMT

Hi,

You can use the first statement.

UPDATE NRIV SET NRRANGENR = number where OBJECT = 'J_1IEXCLOC'.

Thanks,

Sriram Ponna.

Re: UPDATE

Former Member — Fri, 28 Dec 2007 11:19:49 GMT

can you specify how shall i do this

Re: UPDATE

Former Member — Fri, 28 Dec 2007 11:34:23 GMT

hi,

UPDATE NRIV SET NRRANGENR = number where OBJECT = 'J_1IEXCLOC'

or Object in gr_object is correct version.

because when you are updating and dealing with one tableits enough mentioning the table at one part and syntax is also correct for the above only.

Regds

Sivaparvathi

Please reward points if helpful..

Re: UPDATE

Former Member — Fri, 28 Dec 2007 11:59:51 GMT

The main question is why do you want to update a standard number interval (J_1IEXCLOC) ?