Marius,

Good idea I guess, thanks a lot !!

Nico
-----Oorspronkelijk bericht-----
Van: Marius Popa [mailto:mpopa@...]
Verzonden: woensdag 21 februari 2001 6:14
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] Stored Proc question


why don't you make the sum of the colums in another procedure
or if it is too complicated do it in the same procedure like this
(this is
only an ideea )
my procedure ...
return SumOfColumn1,SumOfColumn2,SumOfColumn3....
as
begin
for select xxx
into xxx
do begin
SumOfColumn1=SumOfColumn1+xxx;
suspend;
end
/*now you return the last sum of the columns wich you can find it
with the
Query.Last*/
end

At 19:50 20.02.2001 +0100, you wrote:

>Hi all,
>
> Maybe this is a silly question, but I can't help it, I

don't know

> how to do
>it. The problem is the following :
>I have a stored procedure that is returning let's say 10 rows, and

looks

>something like this :
>
> AText1 10 11 12
> AText2 13 14 15
> AText3 16 17 18 .......
>
>Most of all is numeric data. My question now is : I would like to

make the

>sum of each column. I tried with a calculated field (I make the

sum in the

>OnCalculateField event), but when I move the record pointer, the

sum is

>changing according to how far the recordpointer is in the result

set. If

>the recordpointer is in the last record, it shows the whole sum,

otherwise

>only the sum is shown until where is the recordpointer.
>
>Any help is highly appreciated,
>Many regards,
>
>Nico Callewaert
>
>nico.callewaert@...
>
>
>
>
>
>
>[Non-text portions of this message have been removed]
>
>

Yahoo! Groups Sponsor

www.




Stamp powered by www.mailround.com




[Non-text portions of this message have been removed]