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