How to count total at a cursor field?

[paispatin]

Dear all,

I have a cursor like this :

mycursor field : code, description, amount

How do I counting amount total at mycursor with SELECT SQL?

Thank you in advance

 

[mm0000]

I think you want the total value of the amount fields, if I have understood correctly

You could use :

select sum(amount) from mycursor into cursor mytotal

It will create a cursor with a single field with the total amount.

or for a specific code

select sum(amount) from mycursor where code = 'somecode' into cursor mytotal

HTH

 

[paispatin]

Yes, right. This is what I want.
Thank you very much.