Is there another way like this: update tappl_status set afpool = iif(afpool = 0,1,0) where kommplatz = :kommpl_in;
Von: [email protected] [mailto:[email protected]] Im Auftrag von checkmail Gesendet: Mittwoch, 2. April 2014 09:07 An: [email protected] Betreff: [firebird-support] toggle betweenn 0 and 1 Hello, is there a simple way to toggle between 0 and 1? Update table set column NOT column where id = :id? If column = 1 - then set to 0, else set to 1. Thank you. Best regards Olaf
