topic database insert, update , delete in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/database-insert-update-delete/m-p/9879509#M1789800 <HTML><HEAD></HEAD><BODY><P>Hi expert.&nbsp; this code database table insert, update ,delete .this code broken. help me </P><P><SPAN class="L0S52">DATA </SPAN>: <SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN>itab <SPAN class="L0S52">OCCURS </SPAN>0,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mandt <SPAN class="L0S52">LIKE </SPAN>zpsemih_insert-mandt,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; numara <SPAN class="L0S52">LIKE </SPAN>zpsemih_insert-numara,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; isim <SPAN class="L0S52">LIKE </SPAN>zpsemih_insert-isim,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; soyadi <SPAN class="L0S52">LIKE </SPAN>zpsemih_insert-soyadi,</P><P>&nbsp;&nbsp; <SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN>itab,</P><P>&nbsp;&nbsp; gs_1&nbsp; <SPAN class="L0S52">LIKE </SPAN>itab.</P><P></P><P> <SPAN class="L0S52">PARAMETERS </SPAN>numara1 <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c </SPAN>LENGTH <SPAN class="L0S32">25 </SPAN>.</P><P> <SPAN class="L0S52">PARAMETERS </SPAN>isim1 <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c </SPAN>LENGTH&nbsp;&nbsp; <SPAN class="L0S32">25.</SPAN></P><P> <SPAN class="L0S52">PARAMETERS </SPAN>soyadi1 <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c </SPAN>LENGTH <SPAN class="L0S32">25.</SPAN></P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN>LINE.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON (10) <SPAN class="L0S52">insert </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>inbuton.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON (10) <SPAN class="L0S52">update </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>upbuton.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON (10) <SPAN class="L0S52">modify </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>modbuton.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON (10) <SPAN class="L0S52">delete </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>delbuton.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN>LINE.</P><P></P><P> INITIALIZATION.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">insert </SPAN>= <SPAN class="L0S33">'Insert'</SPAN>.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">update </SPAN>= <SPAN class="L0S33">'Update'</SPAN>.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">modify </SPAN>= <SPAN class="L0S33">'Modify'</SPAN>.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">delete&nbsp; </SPAN>= <SPAN class="L0S33">'Delete'</SPAN>.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">CASE </SPAN>sy-ucomm.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHEN </SPAN><SPAN class="L0S33">'INSERT'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gs_1-numara = numara1.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gs_1-isim = isim1.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gs_1-l = soyadi1.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">INSERT </SPAN>zpsemih_insert <SPAN class="L0S52">from </SPAN>gs_1.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">IF </SPAN>sy-subrc <SPAN class="L0S52">eq </SPAN><SPAN class="L0S33">'0'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">message </SPAN><SPAN class="L0S33">'kayıt eklendi' </SPAN><SPAN class="L0S52">type </SPAN><SPAN class="L0S33">'I'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENDIF.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHEN </SPAN><SPAN class="L0S33">'UPDATE'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">UPDATE </SPAN>zpsemih_insert</P><P> <SPAN class="L0S52">SET&nbsp;&nbsp; </SPAN>isim = isim1&nbsp; soyadi = soyadi1</P><P> <SPAN class="L0S52">WHERE </SPAN>numara = numara1.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHEN </SPAN><SPAN class="L0S33">'MODİFY'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P> gs_1-numara = numara1.</P><P> gs_1-isim = isim1.</P><P> gs_1-soyadi = soyadi1.</P><P> <SPAN class="L0S52">MODIFY </SPAN><SPAN class="L0S52">TABLE </SPAN>itab <SPAN class="L0S52">FROM </SPAN>gs_1 .</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHEN </SPAN><SPAN class="L0S33">'DELETE'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">DELETE </SPAN><SPAN class="L0S52">FROM </SPAN>zpsemih_insert <SPAN class="L0S52">WHERE </SPAN>numara = numara1.</P><P> <SPAN class="L0S31">*&nbsp;&nbsp;&nbsp;&nbsp; WHEN OTHERS.</SPAN></P><P> <SPAN class="L0S31">&nbsp; ENDCASE.</SPAN></P></BODY></HTML> Mon, 11 Nov 2013 09:49:40 GMT Former Member 2013-11-11T09:49:40Z database insert, update , delete https://community.sap.com/t5/application-development-and-automation-discussions/database-insert-update-delete/m-p/9879509#M1789800 <HTML><HEAD></HEAD><BODY><P>Hi expert.&nbsp; this code database table insert, update ,delete .this code broken. help me </P><P><SPAN class="L0S52">DATA </SPAN>: <SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN>itab <SPAN class="L0S52">OCCURS </SPAN>0,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mandt <SPAN class="L0S52">LIKE </SPAN>zpsemih_insert-mandt,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; numara <SPAN class="L0S52">LIKE </SPAN>zpsemih_insert-numara,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; isim <SPAN class="L0S52">LIKE </SPAN>zpsemih_insert-isim,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; soyadi <SPAN class="L0S52">LIKE </SPAN>zpsemih_insert-soyadi,</P><P>&nbsp;&nbsp; <SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN>itab,</P><P>&nbsp;&nbsp; gs_1&nbsp; <SPAN class="L0S52">LIKE </SPAN>itab.</P><P></P><P> <SPAN class="L0S52">PARAMETERS </SPAN>numara1 <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c </SPAN>LENGTH <SPAN class="L0S32">25 </SPAN>.</P><P> <SPAN class="L0S52">PARAMETERS </SPAN>isim1 <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c </SPAN>LENGTH&nbsp;&nbsp; <SPAN class="L0S32">25.</SPAN></P><P> <SPAN class="L0S52">PARAMETERS </SPAN>soyadi1 <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c </SPAN>LENGTH <SPAN class="L0S32">25.</SPAN></P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN>LINE.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON (10) <SPAN class="L0S52">insert </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>inbuton.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON (10) <SPAN class="L0S52">update </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>upbuton.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON (10) <SPAN class="L0S52">modify </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>modbuton.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON (10) <SPAN class="L0S52">delete </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>delbuton.</P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN>LINE.</P><P></P><P> INITIALIZATION.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">insert </SPAN>= <SPAN class="L0S33">'Insert'</SPAN>.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">update </SPAN>= <SPAN class="L0S33">'Update'</SPAN>.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">modify </SPAN>= <SPAN class="L0S33">'Modify'</SPAN>.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">delete&nbsp; </SPAN>= <SPAN class="L0S33">'Delete'</SPAN>.</P><P>&nbsp;&nbsp; <SPAN class="L0S52">CASE </SPAN>sy-ucomm.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHEN </SPAN><SPAN class="L0S33">'INSERT'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gs_1-numara = numara1.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gs_1-isim = isim1.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gs_1-l = soyadi1.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">INSERT </SPAN>zpsemih_insert <SPAN class="L0S52">from </SPAN>gs_1.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">IF </SPAN>sy-subrc <SPAN class="L0S52">eq </SPAN><SPAN class="L0S33">'0'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">message </SPAN><SPAN class="L0S33">'kayıt eklendi' </SPAN><SPAN class="L0S52">type </SPAN><SPAN class="L0S33">'I'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENDIF.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHEN </SPAN><SPAN class="L0S33">'UPDATE'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">UPDATE </SPAN>zpsemih_insert</P><P> <SPAN class="L0S52">SET&nbsp;&nbsp; </SPAN>isim = isim1&nbsp; soyadi = soyadi1</P><P> <SPAN class="L0S52">WHERE </SPAN>numara = numara1.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHEN </SPAN><SPAN class="L0S33">'MODİFY'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P> gs_1-numara = numara1.</P><P> gs_1-isim = isim1.</P><P> gs_1-soyadi = soyadi1.</P><P> <SPAN class="L0S52">MODIFY </SPAN><SPAN class="L0S52">TABLE </SPAN>itab <SPAN class="L0S52">FROM </SPAN>gs_1 .</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHEN </SPAN><SPAN class="L0S33">'DELETE'</SPAN>.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">DELETE </SPAN><SPAN class="L0S52">FROM </SPAN>zpsemih_insert <SPAN class="L0S52">WHERE </SPAN>numara = numara1.</P><P> <SPAN class="L0S31">*&nbsp;&nbsp;&nbsp;&nbsp; WHEN OTHERS.</SPAN></P><P> <SPAN class="L0S31">&nbsp; ENDCASE.</SPAN></P></BODY></HTML> Mon, 11 Nov 2013 09:49:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-insert-update-delete/m-p/9879509#M1789800 Former Member 2013-11-11T09:49:40Z Re: database insert, update , delete https://community.sap.com/t5/application-development-and-automation-discussions/database-insert-update-delete/m-p/9879510#M1789801 <HTML><HEAD></HEAD><BODY><P>Hi Sayin,</P><P></P><P>I think you have to use user-command values at WHEN condition like </P><P><STRONG><SPAN class="L0S52">TABLES </SPAN>sscrfields<SPAN class="L0S55">.</SPAN></STRONG></P><P> <SPAN class="L0S52">PARAMETERS </SPAN>numara1 <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c </SPAN>LENGTH <SPAN class="L0S32">25 </SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S52">PARAMETERS </SPAN>isim1 <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c </SPAN>LENGTH&nbsp;&nbsp; <SPAN class="L0S32">25</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S52">PARAMETERS </SPAN>soyadi1 <SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S52">c </SPAN>LENGTH <SPAN class="L0S32">25</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">BEGIN </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON <SPAN class="L0S55">(</SPAN><SPAN class="L0S32">10</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">insert </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>inbuton<SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON <SPAN class="L0S55">(</SPAN><SPAN class="L0S32">10</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">update </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>upbuton<SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON <SPAN class="L0S55">(</SPAN><SPAN class="L0S32">10</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">modify </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>modbuton<SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN>PUSHBUTTON <SPAN class="L0S55">(</SPAN><SPAN class="L0S32">10</SPAN><SPAN class="L0S55">) </SPAN><SPAN class="L0S52">delete </SPAN><SPAN class="L0S52">USER-COMMAND </SPAN>delbuton<SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S52">SELECTION-SCREEN </SPAN><SPAN class="L0S52">END </SPAN><SPAN class="L0S52">OF </SPAN><SPAN class="L0S52">LINE</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S52">INITIALIZATION</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; <SPAN class="L0S52">insert </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Insert'</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; <SPAN class="L0S52">update </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Update'</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; <SPAN class="L0S52">modify </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Modify'</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; <SPAN class="L0S52">delete&nbsp; </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Delete'</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <STRONG><SPAN class="L0S52">AT </SPAN><SPAN class="L0S52">SELECTION-SCREEN</SPAN><SPAN class="L0S55">.</SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp; <SPAN class="L0S52">CASE </SPAN>sscrfields<SPAN class="L0S55">.</SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">WHEN </SPAN><SPAN class="L0S33">'INBUTON'</SPAN><SPAN class="L0S55">.</SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">MESSAGE </SPAN><SPAN class="L0S33">'Insert command has been triggered' </SPAN><SPAN class="L0S52">TYPE </SPAN><SPAN class="L0S33">'I'</SPAN><SPAN class="L0S55">.</SPAN></STRONG></P><P><STRONG>&nbsp;&nbsp; <SPAN class="L0S52">ENDCASE</SPAN><SPAN class="L0S55">.</SPAN></STRONG></P><P></P><P style="font-size: 12px; background-color: #ffffff; color: #333333;">please do the logic like above and let me know if it resolved are not.</P><P></P><P style="font-size: 12px; background-color: #ffffff; color: #333333;">Regards,</P><P style="font-size: 12px; background-color: #ffffff; color: #333333;">Venkat.</P></BODY></HTML> Mon, 11 Nov 2013 12:29:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-insert-update-delete/m-p/9879510#M1789801 former_member206479 2013-11-11T12:29:48Z Re: database insert, update , delete https://community.sap.com/t5/application-development-and-automation-discussions/database-insert-update-delete/m-p/9879511#M1789802 <HTML><HEAD></HEAD><BODY><P>thank you <SPAN __jive_emoticon_name="grin" __jive_macro_name="emoticon" class="jive_macro jive_emote" src="https://community.sap.com/1925/images/emoticons/grin.gif"></SPAN></P></BODY></HTML> Mon, 11 Nov 2013 13:26:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-insert-update-delete/m-p/9879511#M1789802 Former Member 2013-11-11T13:26:10Z