RE: [development-axapta] Update command

[Tony Depalo]

Title: Message

use

Update_recordset

Tony

-----Original Message-----
From: Jay Sathasivam [mailto:[EMAIL PROTECTED]
Sent: Thursday, 25 March 2004 11:22 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Update command

Hi Guys,

 

I have a table call InventSummary which contain ItemID,InventSize,Inventcolor, QtyOnHand,StockValue,SalesQty,SalesAmount I have created view call InventTransView its shows ItemID,InventSize,InventColor,SalesQty,SalesAmount

 

When I try to do update it's not working. The syntax is

 

 

Update InventSummary

Setting SalesQty = InventTransview.SalesQty,

Salesamount = InventTransview.SalesAmount

Where InventSummary.ItemId == InventTransView.ItemID &&

InventSummary.InventSize == InventTransView.InventSize &&

InventSummary.Inventcolor == InventTransView.InventColor

 

 

Please let me know where I have done wrong.

 

Thanks

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.