SQL-Question

[Claudius Sailer]

Hi,

Am 06. Mrz 2005 um 10:11 Uhr schrieb Claudius Sailer:

I corrected SQL-Statement

> Is it possible to make this in one SQL-Statement like
>
>
>     SQLString="SELECT B.RecID, B.BDatum, KZ.Konto_Name, 
> K.Kategorie_Name,"
>     SQLString=SQLString+" Case when B.Ziel_Konto=KZ.RecID then 
> B.Betrag ELSE null END,"
>     SQLString=SQLString+" Case when B.Herk_Konto=KZ.RecID then 
> B.Betrag ELSE null END,"
>     SQLString=SQLString+" B.Kommentar, B.Blocked"
>     SQLString=SQLString+" FROM Buchungen B, Kategorien K, Konten KZ"
>     SQLString=SQLString+" WHERE B.Kategorie_ID=K.RecID"
>     SQLString=SQLString+ " AND (B.Ziel_Konto=KZ.RecID OR 
> B.Herk_Konto=KZ.RecID)"
>     SQLString=SQLString+ " AND B.Deleted='0'"
>     SQLString=SQLString+ " AND B.Herk_Konto='"+cstr(AktuellesKonto)+"'"
>     SQLString=SQLString+ " ORDER BY B.BDatum, KZ.Konto_Name, 
> K.Kategorie_Name"

SELECT B.RecID, B.BDatum, KZ.Konto_Name, K.Kategorie_Name,
Case when B.Ziel_Konto=KZ.RecID then B.Betrag ELSE null END,
Case when B.Herk_Konto=KZ.RecID then B.Betrag ELSE null END,
B.Kommentar, B.Blocked
FROM Buchungen B, Kategorien K, Konten KZ
WHERE B.Kategorie_ID=K.RecID
AND ((B.Ziel_Konto=KZ.RecID AND B.Herk_Konto='13')
OR (B.Herk_Konto=KZ.RecID AND B.Ziel_Konto='13'))
AND B.Deleted='0'
ORDER BY B.BDatum, KZ.Konto_Name, K.Kategorie_Name

now I get in ViSQL following ErrorMessage

Error 591115	Function "SearchedCase" - wrong param "Else" value.

bye


Claudius