topic Re: updating data base tables in Application Development and Automation Discussions

updating data base tables

Former Member — Tue, 26 Jun 2007 15:36:44 GMT

hi,

i have to update data base table froma table control.

following is my code.

IF V_MODE EQ 'CREATE' AND V_TEMP1 EQ 'Y'.

LOOP AT GT_ADMN_PATNR INTO GS_ADMN_PATNR.

READ TABLE GT_ADMN_PATNR

FROM GS_ADMN_PATNR WITH KEY

DONOR = GT_ADMN_PATNR-DONAR.

IF SY-SUBRC NE O.

MOVE GT_ADMN_ADMN_PATNR TO GT_ADMN_PATNR_SAVE.

ENDIF.

ENDLOOP.

but iam getting error

please revert back as soon as possibe.

kirthi

INSERT ZADMN_PARTNERS FROM TABLE GT_ADMN_PATNR_SAVE.

CLEAR V_TEMP1.

ENDIF.

Former Member — Tue, 26 Jun 2007 15:45:11 GMT

Hello,

USe MODIFY STATEMENT always.

MODIFY ZADMN_PARTNERS FROM TABLE GT_ADMN_PATNR_SAVE.
CLEAR V_TEMP1.

Regards,

Vasanth

Former Member — Tue, 26 Jun 2007 15:49:08 GMT

Use...

MODIFY ZADMN_PARTNERS FROM TABLE GT_ADMN_PATNR_SAVE.

this is useful is already a record exists it updates and if no record exists it inserts the record into the database..

former_member219399 — Tue, 26 Jun 2007 16:01:30 GMT

Use the following syntax

modify ZADMN_PARTNERS FROM TABLE GT_ADMN_PATNR_SAVE.

if sy-subrc = 0.

commit.

endif.

with regards,

Vamsi