DUP v1.1 Short Text File Written by Michael MacDonald 09/09/90 rev 02/26/91 DUP is a compiled Clipper PRG program. It is 'freeware'. No fee is expected or will be accepted. (Well, maybe that's going a little too far. Let's call it 'You Be the Judge Ware' By this I mean, it's free, do whatever you like with it. You're under no obligation, legally or morally to pay me anything for it. But, hey, I'm human. If you feel so inclined, I'm not going to tear up the check.) It's purpose is to check RoboComm's NEWFILES.DBF (the database that keeps track of new files on the BBS's you call) for duplicate file names. It will keep the first occurrence of a duplicate file name in the database and delete the rest. DUP only marks the records as deleted, the database is not 'packed' or reindexed. I have separated the portion of the code that used to automatically pack and reindex the database. It is included in this archive as PACK.EXE. This way you may look at the records that DUP has marked as deleted before actually losing them, if you wish. Also, since the packing and reindexing routines are the most time consuming part of the program you may wish to run NUKE on your database before packing it. DUP can reside anywhere, but you must be in the directory where you keep your RoboComm files when you invoke it. The source code has been included for any Clipper users that wish to play with it. UPDATE: Version 1.1 DUP will now create a text file of the filenames it deletes. (Due to popular demand) The name of the text file is DELETED.FIL. This is the same file that NUKE will write to. Both programs will append to it if it exists, and create it if it doesn't. This way you can see which filenames were deleted. In addition to marking the filenames as deleted, DUP will also tag them. There is a field in the NEWFILES.DBF called TAG, and DUP will set this field true. This can be used to view all the deleted files, not only in the text file DELETED.FIL, but also listed all together in Robo's NEWFILES list. In Robo ver 2.0, do this by choosing BBS as the sort key while viewing the NEWFILES list. Then CNTL/PGDN to go to the bottom of the list. All the files marked as deleted will be there. Try it. The deleted files are sorted on Filename, and all the other files will be sorted the way they should be, on BBS ID. With Robo ver 3.x, there is a sort key called TAGGED, just sort on tagged, then CNT/PGDN as before. Don't be alarmed if you notice the name of the DBF has changed in Robo 3.0. DUP will still work just fine with it, with one exception. You will only see the first line of the file description in the text file DELETED.FIL. This is due to a new method of handling the extended description. DUP will detect which version you're using, and act accordingly. Have fun! Michael MacDonald 15509 183rd Place NE Woodinville, WA 98072