Duplicate pallets

[jcsencsits]

Hi i am trying to get a report for reading duplicates of ld_ref

[FONT=r_ansi]for each ld_det no-lock where
ld_ref >= ref and ld_ref <= ref1.

How would i do this?

Any help Thanks
Jason
[/FONT]

 

[tudorconstantin]

DEFINE VARIABLE cSalesRep1 AS CHARACTER NO-UNDO.
DEFINE VARIABLE cSalesRep2 AS CHARACTER NO-UNDO.
ASSIGN
cSalesRep1 = ""
cSalesRep2 = "".
FOR EACH customer NO-LOCK WHERE cust-num > 10 GROUP BY sales-rep:
cSalesRep1 = customer.sales-rep.
IF cSalesRep1 <> cSalesRep2 THEN
DO:
DISPLAY cSalesRep1 WITH 1 COL.
cSalesRep1 = cSalesRep2.
END.
cSalesRep2 = customer.sales-rep.
END.





This shows you the uniques sales-rep's on the sports database v9 . Here is a WHERE clause to show you where to put your WHERE clause.
I hope this helps.