Updating Database..

[Former Member]

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..

[Former Member]

Hi,

Try using statement COMMIT.

[Former Member]

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

[Former Member]

Hi

Use MODIFY ZASSET FROM WA.

Then check SY-SUBRC.

Put a break point and try debugging.

Thanks