Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do while not eof and scan endscan
Message
From
24/03/2005 01:02:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Do while not eof and scan endscan
Environment versions
Visual FoxPro:
VFP 8
Miscellaneous
Thread ID:
00998758
Message ID:
00998758
Views:
61
Can someone please tell me why I should get two different answers using
"do whil not eof()" and "Scan endscan" as below :

** In this do whil loop, I get 5 records
select kpinx1
zap
select kpin
go top
do whil not eof()
if not empty(dtime1)
skip
loop
endif
if trayout1 = 0 and trayout2=0 and trayout3 = 0
skip
loop
endif
scatter memvar
INSERT INTO kpinx1 from memvar
select kpin
skip
enddo
select kpinx1
go top
brows

*** In this scan loop, I only get 2 recrods
select kpinx1
zap
select kpin
go top
scan
if not empty(dtime1)
skip
loop
endif
if trayout1 = 0 and trayout2=0 and trayout3 = 0
skip
loop
endif
scatter memvar
INSERT INTO kpinx1 from memvar

endscan
select kpinx1
go top
brows

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform