Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Nested scans
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
01379375
Message ID:
01379393
Vues:
19
Hi Gary

What I usually do is store the record number of the table in the outer scan, you can also use indexed fields and use the Scan While command in the inner scan:

select TableA
scan
lnRecord=recno('TableA')
lcKey=TableA.key
select TableB
seek lcKey
scan while TableB.key=lcKey
******
endscan
go lnRecord in TableA && Just in case something in the inner scan changes the record pointer
endscan



HTH
Kevin
Kevin Delaney
Financial Systems Manager
CPL Solutions Ltd

83 Merrion Square, Dublin 2, Ireland.
e: kevin.delaney@cpl.ie w: www.cpl.ie
p: +353 1 482-5368
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform