Iif inside an update satement.

[meet_binay]

The following update query is giving error-- "The operation must use an updatable query" while running...
PLZ help!!

UPDATE MEASUREMENT SET STATUS = ( IIF(
(SELECT SUM(QNTY) FROM Measurement_Individual_Delivery WHERE Measurement_Key_FK=[@KEYS] ) < (SELECT QUANTITY FROM MEASUREMENT WHERE KEYS=[@KEYS]) , 'Pending','Delivered'))


WHERE KEYS=[@KEYS];

[orange]

Please see http://allenbrowne.com/ser-61.html