RE: [development-axapta] How to update table from view

[Preston A. Larimer]

Hi Jay, I don’t think you can use the Update_RecordSet when updating one dataset from another, some one correct me if I’m wrong please.     You could get done what you’re going for with a while select on the view….   While select InventView {               ttsBegin;             select forupdate InventSummary where  InventSummary.ItemID = InventView.ItemId;   InventSummary .SalesQty = InventView.SalesQty; InventSummary .SalesAmount = InventView.SalesAmount; InventSummary.update(); ttsCommit;   }   Not the most efficient, but will get the job done.   -Preston   -----Original Message----- From: Jay Sathasivam [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 8:50 PM To: [EMAIL PROTECTED] Subject: [development-axapta] How to update table from view   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 Sponsor ADVERTISEMENT 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.