topic Re: Updating Database.. in Application Development and Automation Discussions

Updating Database..

Former Member — Tue, 01 Apr 2008 07:43:37 GMT

Hello Gurus,

I have created a database table with a name zasset with fields, serialno, barcode and description.. my requirement is when user enters serialno, description will be displayed and when a user enters barcode, it will automatically assigned to the serialno and barcode number will be added to zasset. field barcode in zasset table in blank..

i did programming to update and it also updates the database table but mine problem is that it takes too much time to update.. is there any suggestions on this?

Regards,

Vikram Salvi..

Re: Updating Database..

Former Member — Tue, 01 Apr 2008 08:01:15 GMT

Hi,

Try using statement COMMIT.

Re: Updating Database..

Former Member — Tue, 01 Apr 2008 08:07:50 GMT

Hi,

Please check that you are not using commit statement inside a loop. Use Commit statement only after the execution of loop.

Secondaly, Check for other performace related factors in programming. Take a trace of your program with ST05 and analyse where the system is taking more time.

Hope this helps.

Regards

Sourabh

Re: Updating Database..

Former Member — Tue, 01 Apr 2008 11:05:58 GMT

Use MODIFY ZASSET FROM WA.

Then check SY-SUBRC.

Put a break point and try debugging.

Thanks