comparing rows !

[make]

Hi , i want to compare some rows of a temp table. When i found some rows wich are equal, they should be get only one row in a new temp table. The last field of the row (called value) should be accumulated.

Example :

Nr. Date Value
112 18.07.02 1
113 18.07.02 2
112 19.07.02 1
115 18.07.02 1
113 18.07.02 2

should be :

Nr. Date Value
112 18.07.02 1
112 19.07.02 1
113 18.07.02 4
115 18.07.02 1

Can i compare whole rows ?

Greets

 

[Gabor Topor]

Hi,

You can use the BUFFER-COMPARE statement which performs a bulk comparison of two records.


Regards,
Gabor