| Subject | Re: [firebird-support] toggle betweenn 0 and 1 |
|---|---|
| Author | W O |
| Post date | 2014-04-03T05:18:21Z |
That's the most simple formula Josef but requires that COLUMN always be 1 or 0, never another number neither NULL.
Greetings.
Walter.
On Thu, Apr 3, 2014 at 1:06 AM, Josef Kokeš <j.kokes@...> wrote:
On 2.4.2014 9:26, Bogdan Mihalache wrote:
>
>
> Update table set *column = Mod(column+1,2)* where id = :id
UPDATE table SET column=1-column WHERE id=:id
Doesn't need any functions, built-in or UDF.
Josef Kokes