topic Re: update statement in Application Development and Automation Discussions

update statement

Former Member — Mon, 24 Jul 2006 11:48:46 GMT

update ztale_head set : send = 'X',

ttime = sy-uzeit,

ddate = sy-datum

where inveno = '227'.

here only record with 227 invoice no shud be updated in ztable but whole ztable is updated with send = 'X' and date and tiem field...

please help.

Re: update statement

Former Member — Mon, 24 Jul 2006 11:50:33 GMT

Maybe a problem with the conversion exit.

Try using the conversion exit on the inveno and then pass it in the condition.

-Aarthi.

Re: update statement

Former Member — Mon, 24 Jul 2006 11:53:36 GMT

Hello,

DO like this..

update ztale_head set : send = 'X',

ttime = sy-uzeit,

ddate = sy-datum

where inveno = '0000000227'.

If useful reward.

Vasanth

Re: update statement

Former Member — Mon, 24 Jul 2006 11:54:54 GMT

Hi Sharma,

Check the Syntax,

UPDATE

Modifies lines in database tables.

Syntax

UPDATE <dbtab> SET <si> = <f>

|<si> = <s i> + <f>

|<si> = <s i> - <f> [WHERE <cond>].

Sets the value in <si> to <f>, increases it by <f>, or decreases it by <f> for all selected lines. The WHERE addition determines the lines that are updated. If you omit the WHERE addition, all lines are updated.

Regards,

Prashanth

Re: update statement

Former Member — Mon, 24 Jul 2006 13:29:40 GMT

Hi,

Check these 2 things,

1)Are you giving the values (inveno = '227')

as youe see them in the DB table.

If not use CONVERSION_EXIT_ALPHA_INPUT to convert it to the input format.

(Next 2 form Documentation)

If you want to change a column of the type STRING, the primary key in the WHERE condition must be fully specified.

3)Do not use the colon and commas to separate chained statements, since you could change an entire database table without wanting to, if you use them wrongly.

* FALSCH * WRONG * FALSCH * WRONG * FALSCH * WRONG * 
* UPDATE SCUSTOM SET:  DISCOUNT  = '003', 
*                      TELEPHONE = '0621/444444' 
*                WHERE ID        = '00017777'.

This code fragment is not a single statement that update the discount and telephone number for the customer with the customer number '00017777'. Rather, it represents two statements - the first changes the discount for all customers, while the second changes the telephone number of the customer with the customer number '00017777'.

So make the following changes and try.



In case of <b>Point 1</b>
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
  EXPORTING
    input  = inveno
  IMPORTING
    output = inveno.


UPDATE ztale_head SET   : send = 'X'
                          ttime = sy-uzeit
                          ddate = sy-datum
               WHERE inveno = <converted value>.


<b>Else do it in this way</b>


UPDATE ztale_head SET   : send = 'X'
                          ttime = sy-uzeit
                          ddate = sy-datum
               WHERE inveno = '227'.

Regards,

AS.