Hello,
I'm trying to update some fields in the OrderFormLineItems table (since
PurchaseOrder.Save is waaay too slow) and seeing some things I don't quite
understand. Basically, the update I'm doing is this:
update OrderFormLineItems set MyExtendedColumn = 'foo' where orderform_id
= oid and lineitem_id = 1
The parameter for oid that I'm passing in is coming from the following:
PurchaseOrder po = MyOrderContext.GetPurchaseOrder(userID, orderGroupID);
foreach (OrderForm form in po.OrderForms)...
foreach (LineItem li in form.LineItems)...
oid = form.Name
Most of the time, form.Name has the GUID that appears in the orderform_id
column of OrderFormLineItems. The problem is when form.Name has a value
of 'Default' or 'default'. Can anyone tell me what this means? Better
yet, how can I get an orderform_id to update in the OrderFormLineItems
table? (or perhaps these line items are stored somewhere else entirely?)
Thanks,
Dave
