V4RB: Question about SQL

[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 ?

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,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------