|
Home > Archive > FoxPro Setup > June 2005 > SET EXACT and SEEK
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SET EXACT and SEEK
|
|
| harvey akerman 2005-06-15, 8:26 pm |
| Can anyone give me a rigorous (or reasonably complete) definition of how
SET EXACT interacts with SEEK.
When I have SET EXACT ON, SEEK always fails.
Thanks in advance.
| |
| Fred Taylor 2005-06-15, 8:26 pm |
| SET EXACT means you must match ALL the characters in the string against the
field value, including the length of the string.
So if your field contains and is indexed on that field: "XXX123"
SEEK "XXX" && fails as the length doesn't match
SEEK "XXX123" && works because it's an "exact" match
With SET EXACT OFF, SEEK "XXX" would find a match.
--
Fred
Microsoft Visual FoxPro MVP
"harvey akerman" <hakerman@ix.netcom.com> wrote in message
news:YM2se.4871$VK4.851@newsread1.news.atl.earthlink.net...
> Can anyone give me a rigorous (or reasonably complete) definition of how
> SET EXACT interacts with SEEK.
> When I have SET EXACT ON, SEEK always fails.
> Thanks in advance.
>
| |
| harvey akerman 2005-06-15, 8:26 pm |
| thanks
Fred Taylor wrote:
> SET EXACT means you must match ALL the characters in the string against the
> field value, including the length of the string.
>
> So if your field contains and is indexed on that field: "XXX123"
>
> SEEK "XXX" && fails as the length doesn't match
> SEEK "XXX123" && works because it's an "exact" match
>
> With SET EXACT OFF, SEEK "XXX" would find a match.
>
|
|
|
|
|