Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get all employee
Message
From
10/02/2005 07:52:35
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 5
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00985090
Message ID:
00985499
Views:
24
hi,
ok, i try as under but no skip to another emplyee he get the first employee evry time
CLOSE ALL

USE MSTR IN 0
SELECT MSTR
M.DAT=DAT
USE tax1 IN 0
SELECT tax1

m.no=NO
m.nMin=1
m.nMax=15
scan WHILE no=M.NO
Select *from tax1 where no=m.no and montno between m.nMin and m.nMax into cursor employees
report form coptax111 preview
Select tax1 &&or select mstr
ENDscan
thanks

>M
>
>Just observing. Are you sure that cursor Employees IS the source for your report? Try "Select Employees" before "report form coptax111 preview"
>
>Also, why don't you get used to using Scan ... Endscan?
>You often have table loops such as
>
>DO WHILE .T. .and. {some condition}
> ... code
> SKIP
> IF EOF()
> EXIT
> ENDIF
>ENDDO
>
>A more elegant form would be:
>
>DO WHILE not EOF() .and. {some condition}
> ... code
> SKIP
>ENDDO
>
>but easier still:
>
>SCAN while {some condition}
> ... code
>ENDSCAN
>
>Terry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform