| Subject | AW: [firebird-support] toggle betweenn 0 and 1 |
|---|---|
| Author | checkmail |
| Post date | 2014-04-02T07:09:43Z |
Is there another way like this:
update tappl_status set afpool = iif(afpool = 0,1,0) where kommplatz = :kommpl_in;
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Im Auftrag von checkmail
Gesendet: Mittwoch, 2. April 2014 09:07
An: firebird-support@yahoogroups.com
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