Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get all employee
Message
De
10/02/2005 07:52:35
 
 
À
10/02/2005 07:33:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 5
Database:
Visual FoxPro
Divers
Thread ID:
00985090
Message ID:
00985499
Vues:
26
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform