I dont think so updating it through Query anlyser would be a harmful for
data. As i had tried many updation on tables using Query anlyser
thanks
On 9/14/05, Cenk Ince <[EMAIL PROTECTED]> wrote:
>
> Hý All
>
> I have made some modifications on inventTransid field on inventTrans. Now
> i want to update InventSettlement and i want to run code form Query
> Analyzer(Because it's Time saving.).
>
> Do you think it's harmful for data?
>
> Thanks.
>
>
>
> Update bmssa.INVENTSETTLEMENT Set
> bmssa.INVENTSETTLEMENT.InventTransId = bmssa.INVENTTRANS.InventTransId
> from bmssa.INVENTSETTLEMENT WITH(INDEX(I_173RECIDTYPEIDX)),
> bmssa.INVENTTRANS WITH(INDEX(I_177RECID))
> Where bmssa.INVENTTRANS.TransRecID = bmssa.INVENTSETTLEMENT.recId AND
> bmssa.INVENTTRANS.InventTransId <> bmssa.INVENTSETTLEMENT.InventTransIdAND
> bmssa.INVENTTRANS.dataAreaId = 'SPK' AND bmssa.INVENTSETTLEMENT.dataareaID= 'SPK'
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
