Look at Your equality operator in the where clause;
You forgot double equal signs, try:
Where InventSummary.ItemID == InventView.ItemId;
Best Regards
Steffan
--- Jay Sathasivam <[EMAIL PROTECTED]> wrote:
> 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.
__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html
| Yahoo! Groups Sponsor | |
|
|
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.
