[development-axapta] How to update table from view

[Jay Sathasivam]

Hi Guys,

 

I have a InventSummary table the fields are ItemID,QtyOnHand,StockValue,SalesQty,SalesAmount

and the view name InventView and the field names itemId, SalesQty, SalesAmount

When I write Update command it's not working. The syntax is

 

Update_recordset InventSummary

Setting  SalesQty = InventView.SalesQty,

SalesAmount = InventView.SalesAmount

Where InventSummary.ItemID = InventView.ItemId

 

 

Please help me.

 

Best Regard

Jay

Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.

---

Yahoo! Groups Links

• To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
   
• To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]
   
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.