home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
workdb.zip
/
DUPCHECK.PRG
< prev
next >
Wrap
Text File
|
1988-08-15
|
834b
|
28 lines
*!!* dBASE CONVERT - dBASE III File Conversion Aid v2.01 1/10/86
*
SET HEADING OFF
SET SAFETY OFF
* dupcheck.sig 08/18/83
* this module checks to see if there are records with the same lastnames
* you can make it a tighter test with relative ease.
SAVE TO TEMP1
RELEASE ALL
GOTO TOP
STORE .T. TO MORE
DO WHILE more .AND. (.NOT. EOF())
* display something to read while searching for duplicates
CLEAR
@ 07,10 SAY 'SEARCHING FOR DUPLICATE LAST NAMES'
* save the current name, in upper case, for comparison
STORE UPPER(lname) TO oldlname
* move to the next record to compare
SKIP
* if match is found and eof has not been reached
* let user look at both and decide what to do
IF oldlname = UPPER(lname) .AND. (.NOT. EOF())
DO DUPREC.PRG
ENDIF
ENDDO
RESTORE FROM TEMP1