Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using $ in a seek search
Message
De
27/12/2007 14:41:51
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Conférences & événements
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01277888
Message ID:
01277891
Vues:
15
>I am using:
>
>LOCATE FOR 'ARNOL' $ UPPER(MYTEXTBOX)
>
>In a indexed table, is there a way to use "seek"
>in the code below instead of locate ?

Seek not - it works from the beginning of the key, i.e. seek() is actually a fast version of "locate for {keyexpression}=lcStringToFind" (and the equal sign behaves with the usual "to the length of the right one" rules).

You may try SQL version of that, by either doing

select ... where 'ARNOL' $ UPPER(MYTEXTBOX)

or

select ... where UPPER(MYTEXTBOX) like '%ARNOL%'

Not sure any of this is optimizable, even if you have a tag on UPPER(MYTEXTBOX).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform