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
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:
Yes, that's the most simple way I can think of.
Am 02.04.2014 09:09, schrieb checkmail:
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
On Wed, 2 Apr 2014 09:07:25 +0200, checkmail check_m...@satron.de
wrote:
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.
Sure:
COLUMN = 1 - COLUMN (however this assumes that the column is NOT
Update table set column = Mod(column+1,2) where id = :id
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Mark Rotteveel
Sent: Wednesday, April 2, 2014 10:16 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] toggle betweenn
On 01 Apr 2014 22:13:30 -0700, venussof...@gmail.com wrote:
Hi all
I wanted my user of the software to use formatted / filtered data on
their
mobile. MyData is a fine app I had in mind to allow them to view data
on
the Android mobiles with SQLite being native to Android I was wondering
if
I
..good idea, thanks @ll
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Im Auftrag von Bogdan Mihalache
Gesendet: Mittwoch, 2. April 2014 09:26
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] toggle betweenn 0 and 1
Update table set
Hi,
I'm using the ODBC driver to access Firebird databases.
It is working nice.
I have two databases and I can access them simultaneously with two
connection objects.
My question is:
Is it possible to have one SELECT UNION ... statement that gets
data from both database?
Currently I
I'm using the ODBC driver to access Firebird databases.
It is working nice.
I have two databases and I can access them simultaneously with two
connection objects.
My question is:
Is it possible to have one SELECT UNION ... statement that gets
data from both database?
Currently I
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
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.ko...@apatykaservis.czwrote:
On 2.4.2014 9:26, Bogdan Mihalache wrote:
Update table set *column =
Am 2014-04-03 07:18, schrieb W O:
That's the most simple formula Josef but requires that COLUMN always be
1 or 0, never another number neither NULL.
Which is easy to achieve using a CHECK constraint on the column
with kind regards,
Michael
13 matches
Mail list logo