Deleting duplicates from detail sets - thanks for the tips

[=?iso-8859-1?Q?Benny_M=F8ller=2C_ScanConsult?=]

Thanks for the response on my question on removing duplicates.

I ended up using the following suggestion from Martin McDonough:

ACC FILENAME
DEF D-UNIQUE-KEY = FIELDA + FIELDB
SORT ON D-UNIQUE-KEY
TEMP T-COUNT NUM*9
  ITE T-COUNT COUNT RESET AT D-UNIQUE-KEY
OUT FILENAME DEL IF T-COUNT <> 1
GO

That worked fine.


Benny Møller

====================================================================
E-mail: bm@scanconsult.dk                Cell Phone: +45 23 43 89 67
====================================================================
ScanConsult IT-Partners                    Voice   : +45 87 34 55 07
Udviklingsparken Aarhus                    Fax     : +45 87 34 15 07
Soenderhoej 46                      Support : support@scanconsult.dk
DK-8260 Viby J.                     Sales   :   sales@scanconsult.dk
Denmark                             Web  : http://www.scanconsult.dk
===     M A C H  :  Menu-based  Air  Cargo  Handling  system     ===
===       ScanConsult is Authorized by Hewlett-Packard as:       ===
===     *    HP 3000 Select Independent Software Vendor    *     ===
===     **             HP9000  Power  Partner             **     ===

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.