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]
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo