Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek
Message
From
18/04/2004 04:09:55
 
 
To
18/04/2004 01:15:24
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Seek
Miscellaneous
Thread ID:
00895885
Message ID:
00895909
Views:
15
>Hi To All,
>
>i have a table tbl_x with an index field1 + field2 TAG ifield
>
field1 = '     12345'
field2 = 'AA'

i tried to used seek'     12345' no records found, but
seek'     12345AA' it works good.

what can i do seek'     12345'only ?
>i set EXACT OFF and NEAR ON
>
>pls help,
>
>TIA.

Ryan. You do not need NEAR ON for this. But set EXACT OFF. Just
SEEK('     12345')
will work. You can seek just for the first part of the index key. However, I suspect that you are not matching the first part of the key. Display you key for the record ie. field1 and display the string you are using to search ie. ' 12345'.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Reply
Map
View

Click here to load this message in the networking platform