-
[Query[ 100% to +7
Code:
UPDATE ITEM_UPGRADE
Set nGenRate = '10000'
WHERE (nReqItem1 = '700002000') AND (nGenRate = '1500')
UPDATE ITEM_UPGRADE
Set nGenRate = '10000'
WHERE (nReqItem1 = '700002000') AND (nGenRate = '4000')
UPDATE ITEM_UPGRADE
Set nGenRate = '10000'
WHERE (nReqItem1 = '700002000') AND (nGenRate = '6000')
UPDATE ITEM_UPGRADE
Set nGenRate = '10000'
WHERE (nReqItem1 = '700002000') AND (nGenRate = '7000')
Credits to equalled for providing query.
Credits to me for posting and expanding the query.
-
Re: [Query[ 100% to +7
thanks ceelen!
i've been trying to figure this out