Another User modified Table (ODBC -2039) - Sales order

[lars_jnsson]

Via a button on sales order form I delete some of the order lines with oMatrix.DeleteRow(rowNr).

It works fine but the DocTotal is not updated as it will be if I delete the row manually with the right-click Delete Row command.

When saving the order via Update button it refuses with the error "Another User modified Table (ODBC -2039)".

Do you have any ideas for workarounds for this?

I've tried to set the price to 0 before deleting the row (the DocTotal will be updated) but the error is the same when saving.

I don't manipulate the FormMode in the code.

Regards

Lars

[lars_jnsson]

Sorry, I can't find any release note about this error in PL49.

Regards

Lars

[Former Member]

Dear Petr,

I am on PL49 and i am still encountering this error.

Any more ideas?

Regards,

Lip Sin

Edited by: Lip Sin Wong on Sep 16, 2009 8:12 AM

[Former Member]

hi,

i also using Patch Level 49 an i got the same error after i deleted some order lines by code.

Has anybody found a solution?

regards

Markus

[Former Member]

hi,

i get the same error in 2007A SP01 PL6 hotfix

best regards

Markus

[Former Member]

Did anybody of you ever solve this? I am on 2007A SP01 PL 10 and still having this issue...

Thanks,

Joerg.

[Former Member]

Hi,

i also get the error in SAP 8.8 SP00 PL08 hotfix 2,

when i do many changes on order.

Does anybody found a solution?

best regards

Markus

[paolo_caricasole]

I've got the same issue on 2007A SP01 PL09.

Has anybody posted a SAP message?

I'm going to do this.

Best regards,

Paolo.

[paolo_caricasole]

HI,

SAP has answered with notes 720076.

They suggest to use

oMatrix.Columns.Item("1").Cells.Item(i).Click()
SBO_Application.ActivateMenuItem("1293")

instead of

oMatrix.DeleteRow(i)

It works for me.

Best regards,

Paolo.

[lars_jnsson]

Hi Petr!

I run PL46 on 2007. I shall directly read the release notes...

Regards

Lars

[Former Member]

Lars, which version and patch are you using? I saw, that this error was fixed in PL49 of SBO2007 (in overview note for PL49). Maybe it helps you.