Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate??
Message
 
To
17/03/1998 09:48:30
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00084986
Message ID:
00085052
Views:
43
Well, not really. Like I said, the scope is REST. In the help file under the LOCATE command, you will find that the WHILE clause is separate than the Scope clause. If you execute the LOCATE WHILE REST command, you get the same result as the LOCATE WHILE command. This is not the same result that you will get with the LOCATE WHILE ALL command (unless you are at the top of the table). In other words: "This means the WHILE clause changes the default scope from ALL to REST.."

BTW, did you miss when I stated "I'm not sure, because I always include the REST clause in this situation"?

This was not an attempt to begin a debate on a trivial subject. This was meant to help the person in case the REST clause was needed in case she ran into problems.

Joe


>WHILE lExpression2
>Specifies a condition whereby records are searched for as long as the logical expression lExpression2 evaluates to true (.T.).
>So, WHILE provides a scope.
>
>>Like I said, I'm not sure...
>>This means the WHILE clause changes the default scope from ALL to REST..
>>
>>Take care,
>>Joe
>>
>>>Why? WHILE clause will serve this purpose.
>>>
>>>>I'm not sure, because I always include the REST clause in this situation, but you may have to include the REST clause in this locate...
>>>>
>>>>Joe
>>>>
>>>>
>>>>
>>>>>>I have a pageframe used for browsing a record that is based on
>>>>>>a job number and a check digit 8797-01. I need to locate the job number and then continue to locate the appropriate check digit, 01, 02 03 etc.
>>>>>>
>>>>>>Locate works well to find job number, but I cannot get it to search
>>>>>>for the check digit. How can I have it find the job no. and then contine on to find correct ck digit?
>>>>>>
>>>>>>Thanks and have a good day.
>>>>>
>>>>>
>>>>>Select table1
>>>>>set order to tag jobnumber
>>>>>Seek myjobnumber
>>>>>If found()
>>>>> Locate for table1.checkdigit=mycheckdigit while table1.jobnumber=myjobnumber
>>>>>Endif
>>>>>
Joseph C. Kempel
Systems Analyst/Programmer
JNC
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform