V4RB: Question about SQL

[Ivan Smahin]

Ruslan Zasukhin пишет:
> On 1/1/05 6:44 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:
> 
> 
>>Hi,
>>
>>I have 2 Functions which calculates 2 values out of one table. Is it
>>possible to bring this with valentina 2 in one function in one
>>SQL-Statement?
> 
> 
>>The problem is, that the values in every function could by bigger then
>>RB integer but the diffence of both normally never.
>>
>>IMHO I think following would bring solution, when it will work in V4RB
>>2.X
>>
>>SELECT
>>( SELECT SUM(Betrag)
>>    FROM Buchungen
>>   WHERE Ziel_Konto=KontoRecID
>>   AND BDatum>'StartDatum'
>>  AND BDatum<='Enddatum'
>>   )
>>-
>>( SELECT SUM(Betrag)
>>    FROM Buchungen
>>    WHERE Herk_Konto= KontoRecID
>>     AND BDatum>'StartDatum'
>>      AND BDatum<='Enddatum'
>>   )
> 
> 
> Yes this should works. Right Ivan ?
> 
Seems to be correct.

> Claudius, you have any problems with this query ?
> 
> 
> 
>>But with V4RB 1.10 this wouldn't work or is this wrong?
> 
> 
> Yes in 1.10 this will not work.
> 
> 


-- 
Best regards,
Ivan Smahin.