Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nested scans
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01379375
Message ID:
01379393
Views:
18
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
Previous
Reply
Map
View

Click here to load this message in the networking platform