Dino wrote:
>
> Hi All,
>
> I have a big problem to me:
>
> I need to query a database having the values cumulated. Something like this:
>
> Num| Name | MonthValue | cumulated
> --------------------------------------------------------
> 1 | aname | 10 | 10
> 2 | othername | 15 | 25
> 3 | otherone | 3 | 28
>
> That row "num" is another question: can I have a enumerated result? How?
>
> Thanks in advance
Hi Dino
No, you can't cumulate like this in an SQL DB.
So you have to do this on the client side.
The enumeration can be done, but only via inserting the result into a temporary table
which has the Num field as AUTO_INCREMENT.
Tschau
Christian
PS: Sorry for the late answer, I was really busy.
