Skip to Content
Former Member
May 31, 2006 at 05:24 PM

Problem updating partially shipped order


Hey All,

I am working on an application for a client on SBO 2004 patch level 29. I complete a query to find a recordset of open orders.

I then loop over the open orders and load the document object to update the warehouse code field in each line item.

The recordset gives me three line items, one of which is closed.

I have to check the line item to make sure its status is not C for closed and I do not update that line item. then I called the document.update method and I get the following error message:

" [RDR1.VatSum][line: 1] , 'Field cannot be updated (ODBC -1029)'"

I have even tried hardcoding the setcurrentline method to 1 or 2 index which should completely skip the line item that is closed and same problem.

I am not even touching this field through my code.

Please someone help me solve this issue.