Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange SEEK
Message
 
 
À
14/03/2009 19:06:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Divers
Thread ID:
01388076
Message ID:
01388140
Vues:
45
It's faster to SET ORDER in separate command. When you use ORDER clause in USE command in addition to setting order VFP also moves pointer to the first record in that order. It can take additional time.
USE names
SET ORDER TO code
>
>cCode="KHAN"
>Use names order code
>If Seek(cCode)
>   ?yes
>Else
>   ?no
>Endif
>
>>Hi Tore, Can please give me an example of seek() for this code :
>>
>>Local cCode
>>cCode="KHAN"
>>sele 0
>>use invoice
>>set order to code
>>sele 0
>>use names
>>set order to code
>>
>>sele names
>>seek cCode && this is what I do now
>>if found()
>> ?yes
>>else
>> ?No
>>endif
>>
>>sele invoice
>>seek cCode
>>
>>..
>>..
>>Many thanks.
>>Shafid
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform