2007 Jun 26 4:36 PM
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.
2007 Jun 26 4:45 PM
Hello,
USe MODIFY STATEMENT always.
MODIFY ZADMN_PARTNERS FROM TABLE GT_ADMN_PATNR_SAVE. CLEAR V_TEMP1.
Regards,
Vasanth
2007 Jun 26 4:49 PM
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..
2007 Jun 26 5:01 PM
Hi
Use the following syntax
modify ZADMN_PARTNERS FROM TABLE GT_ADMN_PATNR_SAVE.
if sy-subrc = 0.
commit.
endif.
with regards,
Vamsi
Bluesky
