Topic: Databse Caclucated field IIF or CASE
hi everyone,
Can I use IIF in my query in mvdb?
I just tried them both but not working. maybe my query have problem!
here it is:
(SELECT id_boxes, is_terminated IIF(boxes.id = bookings.id_boxes AND bookings.is_terminated = False,'Booked','Free') FROM bookings)
And this is CASE
(SELECT id_boxes,is_terminated CASE WHEN boxes.id = bookings.id_boxes AND bookings.is_terminated = False THEN 'Ja' ELSE 'Nein' END category FROM bookings)
I just want to know if a box is booked or not. it better to return boolean but I don't know how to replace yes no with other words in grid!
Many Thanks