J
Jonathan Wood
I'm trying to implement the following query:
UPDATE ScheduledDeliveries SET TargetDeliveries=IIF((TargetDeliveries +
@Increment) >= 0, TargetDeliveries + @Increment, 0)
WHERE ContractID=@ContractID AND CategoryID=@CategoryID AND DueDate=@DueDate
But I get the error: Incorrect syntax near '>'.
Can anyone spot my problem?
Thanks.
Jonathan
UPDATE ScheduledDeliveries SET TargetDeliveries=IIF((TargetDeliveries +
@Increment) >= 0, TargetDeliveries + @Increment, 0)
WHERE ContractID=@ContractID AND CategoryID=@CategoryID AND DueDate=@DueDate
But I get the error: Incorrect syntax near '>'.
Can anyone spot my problem?
Thanks.
Jonathan