Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LOCATE
Message
From
21/08/2000 13:30:21
 
 
To
21/08/2000 12:22:22
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: LOCATE
Miscellaneous
Thread ID:
00407349
Message ID:
00407412
Views:
20
>The reason I wanted to try the LOCATE was cause with the SEEK() does not work correctly. This is what I’m doing:
>
>IIF(SEEK(THISFORM.r_year+result.source,'Temp','Temp'),Temp.descr," ")
>
>It doesn’t find the right info, although, it does exist. I also tried setting EXACT ON and still doesn’t find it.
>
>any ideas?

That's why I included the PADR() on the fyr and source fields, so the length of the expression matches the length of the field.
Make sure the index expression is fyr+source.
If you want to use the form properties, ALLTRIM() them first, e.g.
lcSearch = PADR(ALLTRIM(thisform.r_year),FSIZE("fyr","temp"))+ ;
    PADR(ALLTRIM(result.source,FSIZE("source","temp"))
IIF(SEEK(lcSearch, "temp", "temp"),temp.descr," ")
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform