Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can use seek to perform like locate withg dowhile?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How can use seek to perform like locate withg dowhile?
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01153661
Message ID:
01153661
Vues:
60
How can I duplicate the following code using the seek command:
 SCAN
 SELECT Invoice
 LOCATE FOR in_code = lnCustCode
   DO WHILE FOUND()
     do some code
     CONTINUE
   ENDDO
 SELECT sometable
 ENDSCAN
The is extremely slow as this codes is already in another loop and therefore a locate for the whole table is execute each time.

Thanks in advance.
Stuart Reid

True nobility lies not in being superior to another man, but in being superior to one’s previous self
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform