Apr 30, 2021
Posted by VANTIQ Support

Vantiq does not support this kind of update syntax currently in VAIL so you have to do a SELECT ONE, followed by the UPDATE, like this:

var current = SELECT EXACTLY ONE FROM order_detail where id == 123

UPDATE order_detail(amount: current.amount + 100) where id == 123


© Vantiq 2024 All rights reserved  •  Vantiq Corporation’s Privacy Policy and Cookie Policy