Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using $ in a seek search
Message
From
27/12/2007 14:41:51
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Conferences & events
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01277888
Message ID:
01277891
Views:
14
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform