topic Re: Problem with updating database in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-updating-database/m-p/6371356#M1401829 <HTML><HEAD></HEAD><BODY><P>Thanks Abhi,</P><P></P><P>I am already using commit work statement after that.</P></BODY></HTML> Thu, 19 Nov 2009 15:17:55 GMT Former Member 2009-11-19T15:17:55Z Problem with updating database https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-updating-database/m-p/6371354#M1401827 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>I have a issue with updating the database.Below is the statment by which i am modifying the database.</P><P> MODIFY ZSRM_DET_ALRTS FROM TABLE FP_I_MOD_TABLE .</P><P></P><P>The isssue is when i am running the program the data is getting modified correctly. In production there is a job scheduled to run the program . I see that in production the data is not getting properly updated in this table.From the past 5 to 6 months the issue has increased. </P><P>Currently the total no of records in the table ZSRM_DET_ALRTS is 530. Below is the technical description os the table</P><P>Data class-APPL1</P><P>Size Catagory - 1.</P><P></P><P>What can be going wrong . I tried running the program in production but it is working fine there and the table is getting updated. </P><P></P><P>Pls Help.</P><P>Rohit</P></BODY></HTML> Thu, 19 Nov 2009 15:02:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-updating-database/m-p/6371354#M1401827 Former Member 2009-11-19T15:02:57Z Re: Problem with updating database https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-updating-database/m-p/6371355#M1401828 <HTML><HEAD></HEAD><BODY><P>Hi Rohit,</P><P></P><P>Use FM <STRONG>DB_COMMIT</STRONG> after insert.</P><P></P><P>This will definitely help you.</P><P></P><P>Kindly set to resolved if it helps you.</P><P></P><P>Regards</P><P><STRONG>Abhii</STRONG></P></BODY></HTML> Thu, 19 Nov 2009 15:09:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-updating-database/m-p/6371355#M1401828 Former Member 2009-11-19T15:09:13Z Re: Problem with updating database https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-updating-database/m-p/6371356#M1401829 <HTML><HEAD></HEAD><BODY><P>Thanks Abhi,</P><P></P><P>I am already using commit work statement after that.</P></BODY></HTML> Thu, 19 Nov 2009 15:17:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-updating-database/m-p/6371356#M1401829 Former Member 2009-11-19T15:17:55Z