|
Posted by Sad on September 29, 2008, 8:47 am
Please log in for more thread options
thank you kaibin
i tried this trigger on HQ it was ok ( thier is little change)
CREATE TRIGGER [utr_Item_Cost_LowerBound_Insert] ON [Item]
FOR INSERT, UPDATE
AS
IF UPDATE (PRICE)
/***************************************************
utr_Item_Cost_LowerBound_Insert sets LowerBound to Price * .9%
when item Price is updated or item created.
***************************************************/
BEGIN
UPDATE Item
SET PRICELowerBound = i.price * .9 ,PRICEA = i.price * .95 , PRICEB=
i.price * .9 ,PRICEC= i.price * .85
FROM Item INNER JOIN INSERTED i on Item.ID= i.ID
END
"Kaibin" wrote:
> yes, can be used in HQ, and the syntax looks correct. any problems w/ it?
>
> --
> Kaibin
> RMS Support Team
> Ridge, Inc.
> http://www.ridgeinc.com.cn
> > HI,
> > i am a bigginer in sql ,Is the following trigger can be used in HQ ?( i
> > modified it from this forum )
> > thanks
> >
> >
> > CREATE TRIGGER [utr_Item_Cost_LowerBound_Insert] ON [Item]
> > FOR INSERT, UPDATE
> > AS
> > IF UPDATE (PRICE)
> > /***************************************************
> > utr_Item_Cost_LowerBound_Insert sets LowerBound to price * 0.9%
> > when item is created.
> >
> > ***************************************************/
> > BEGIN
> > UPDATE Item
> > SET PRICELowerBound = i.price * .9
> > SET PRICEA = i.price * .95
> > SET PRICEB= i.price * .9
> > SET PRICEB= i.price * .85
> > FROM Item INNER JOIN INSERTED i on Item.ID= i.ID
> > END
> >
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap