need help!!!

[make]

Hi there,

i have a big problem.
i have a temp table like this

Field A Field B
-------- --------
110 65
110 65
110 70
110 70
120 65
120 65
120 70
120 70

You See there a some doubles !
I need a result like this : ( destroy the doubles)

Field A FieldB
--------- ----------
110 65
110 70
120 65
120 70


How can i do that ?

Pleaaaaaaaseeeeeeee !!!!!!!!!

make

 

[Norman Biggar]

DEF TEMP-TABLE Temp_Table NO-UNDO
FIELD FieldA AS INT
FIELD FieldB AS INT
INDEX IndexA IS PRIMARY
FieldA ASCENDING
FieldB ASCENDING.

FOR EACH Temp_Table
BREAK BY FieldA
BY FieldB:
IF LAST-OF(FieldB) THEN
DISPLAY FieldA FieldB.
END.

 

[make]

thanx

hey ,
it works !
thanx very much.

P.S. we won 2:0 against Kamerun !!!!!!!Yipihhhhhhh!!!!!

Greets
make