I am not able to run Update query for my mobile app using SQL more for MS SQL Server.
Query:
update tbl_boxes_outstanding
set outstanding_big = outstanding_big - {{BigBoxes_N.value}}, outstanding_small = outstanding_small - {{SmallBoxes_N.value}}
where Name LIKE '{{UsersSelect.value}}'
I tried to use GUI Mode but it does not allow filtering on strings(using MS SQL server in the backend)
It gives no error but also does not update the DB records.