Re: [firebird-support] Synchronisation between two processes

2014-07-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Sorry, from my phone, sobad formatting and terse. What transaction isolation mode(s) are you using? Ordinarily direct file access is limited to one process. What version of Firebird? Ann On Jul 11, 2014, at 10:31 AM, Bryan Cole bryan.c...@teraview.com [firebird-support]

[firebird-support] Subquery and returning 0

2014-07-12 Thread Łukasz Bączek bacze...@o2.pl [firebird-support]
Hello, I have a SQL query: SELECT CASE WHEN umowy.numer_umowy IS NULL THEN 0 END AS numer_umowy FROM umowy WHERE umowy.data_podpisania IS NOT NULL AND umowy.id_wnioski IN (SELECT CASE WHEN wnioski.id_wnioski IS NULL THEN 0 END AS id_wnioski FROM wnioski LEFT JOIN kategorie_wnioskow ON

Re: [firebird-support] Subquery and returning 0

2014-07-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 12-7-2014 15:57, Łukasz Bączek bacze...@o2.pl [firebird-support] wrote: Hello, I have a SQL query: SELECT CASE WHEN umowy.numer_umowy IS NULL THEN 0 END AS numer_umowy FROM umowy WHERE umowy.data_podpisania IS NOT NULL AND umowy.id_wnioski IN (SELECT CASE WHEN wnioski.id_wnioski IS

Re: [firebird-support] Subquery and returning 0

2014-07-12 Thread Łukasz Bączek bacze...@o2.pl [firebird-support]
W dniu 12.07.2014 16:01, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] pisze: On 12-7-2014 15:57, Łukasz Bączek bacze...@o2.pl [firebird-support] wrote: Hello, I have a SQL query: SELECT CASE WHEN umowy.numer_umowy IS NULL THEN 0 END AS numer_umowy FROM umowy WHERE

ODP: Re: [firebird-support] Subquery and returning 0

2014-07-12 Thread Piotr Olszewski piotr.olszew...@eskrzynka.pl [firebird-support]
Hej Jak poprzednicy do końca nie wiem o co Ci chodzi. Może zamiast case when wykorzystaj funkcję COALESCE, która zwraca pierwsza wartość nie Null. Chyba ze po prostu zapytanie nie zwraca Ci żadnych pozycji wówczas będziesz miał zawsze null. Jeśli Ci nie za bardzo pomogłem lub potrzebujesz

Re: ODP: Re: [firebird-support] Subquery and returning 0

2014-07-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 12-7-2014 17:07, Piotr Olszewski piotr.olszew...@eskrzynka.pl [firebird-support] wrote: On 12-7-2014 15:57, Łukasz Bączek bacze...@o2.pl [firebird-support] wrote: Hello, I have a SQL query: SELECT CASE WHEN umowy.numer_umowy IS NULL THEN 0 END AS numer_umowy FROM umowy WHERE

Re: [firebird-support] User management defective

2014-07-12 Thread Matthias Hanft m...@hanft.de [firebird-support]
Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: At a minimum I'd suggest that you upgrade to Firebird 2.0.7 and/or check the 2.0.7 release notes if 2.0.4 - 2.0.7 contain any bugfixes that might hint at a problem like this. Hmmm... got the 2.0.7.tar.gz from firebirdsql.org and

Re: [firebird-support] Subquery and returning 0

2014-07-12 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
I have a SQL query: SELECT CASE WHEN umowy.numer_umowy IS NULL THEN 0 END AS numer_umowy FROM umowy WHERE umowy.data_podpisania IS NOT NULL AND umowy.id_wnioski IN (SELECT CASE WHEN wnioski.id_wnioski IS NULL THEN 0 END AS id_wnioski FROM wnioski LEFT JOIN kategorie_wnioskow ON

Re: [firebird-support] Subquery and returning 0

2014-07-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 12-7-2014 18:30, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote: Your statement is equivalent to CASE WHEN umowy.numer_umowy IS NULL THEN 0 ELSE NULL END, so I think your problem simply is that NULL is returned if numer_umowy has a value. You may get

[firebird-support] after updates

2014-07-12 Thread slu...@iquanta.com [firebird-support]
hello one and all, i know i am probably the last holdout from v1.5 to v2.5. i am currently using 2.5.2.26540. i have been distracted. i have narrowed my problem down to an AFTER UPDATE trigger. essentially, i can not update a table, called RC_1, unless i have inactivated or deleted an AFTER