updating data base tables

[Former Member]

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]

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]

Hello,

USe MODIFY STATEMENT always.

MODIFY ZADMN_PARTNERS FROM TABLE GT_ADMN_PATNR_SAVE.
CLEAR V_TEMP1.

Regards,

Vasanth

[Former Member]

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]

Hi

Use the following syntax

modify ZADMN_PARTNERS FROM TABLE GT_ADMN_PATNR_SAVE.

if sy-subrc = 0.

commit.

endif.

with regards,

Vamsi