Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to find the only one record for duplicate address?
Message
De
10/12/1998 10:33:15
Senna Dwipayana
Indo Rebel Apparel Cv
Bandung, Indonésie
 
 
À
09/12/1998 13:49:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00165174
Message ID:
00166068
Vues:
13
Try this
SET DELETED ON
CREATE CURSOR myTempCursor (name C(200),dob D,address C(200))
SELECT * from mytempTable INTO ARRAY myArray
IF _TALLY<>0
INSERT INTO myTempCursor FROM ARRAY myArray
ENDIF

SELECT myTempCursor
SCAN
mdob=dob
mAddress=address
mrec=Recno()
SELECT COUNT(*) FROM myTempCursor WHERE dob UPPER(ALLT(address))==UPPER(ALLT(maddress)) ;
AND RECNO()#mrec INTO ARRAY atempcount
IF aTempCount<>0
DELETE
ENDIF
ENDSCAN
HTH
Senna Dwipayana
Being good is better
Being better is a bless
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform