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