FIXED 619

Claudius Sailer Claudius at sailer-online.de
Fri Apr 8 18:20:37 CDT 2005


Am 08. Apr 2005 um 18:18 Uhr schrieb Claudius Sailer:

> SQLString=SQLBuilder(33,false,cstr(AktuellesKonto))

I Forgot SQLString is following Code

SELECT B.RecID, B.BDatum, KZ.Konto_Name, K.Kategorie_Name, B.Betrag, 
null, 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')
AND B.Deleted='0'
UNION
SELECT B.RecID, B.BDatum, KZ.Konto_Name, K.Kategorie_Name, null, 
B.Betrag, B.Kommentar, B.Blocked
FROM Buchungen B, Kategorien K, Konten KZ
WHERE B.Kategorie_ID=K.RecID
AND (B.Herk_Konto=KZ.RecID AND B.Ziel_Konto='13')
AND B.Deleted='0'
ORDER BY B.BDatum, KZ.Konto_Name, K.Kategorie_Name

bye


Claudius



More information about the Valentina mailing list