Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Handi Rusli
  Where is Handi Rusli?
 Jakarta
 Indonesia
 Handi Rusli
 To: Joriveek Joriveek
  Where is Joriveek Joriveek?
 
 Argentina
 Joriveek Joriveek
 Tags
Subject: RE: LOCATE command in VFP
Thread ID: 19874 Message ID: 19875 # Views: 2 # Ratings: 0
Version: Visual FoxPro 7 Category: General VFP Topics
Date: Thursday, February 06, 2003 11:05:32 AM         
   


> HI,
>
> I want to search for a record which falls in between two values/range. Can I search it with use of Locate command. I have done it before but now I can't remember how did I do it. I like the syntax of LOCATE says that only it accepts LOGICAL EXPRESSIONS (like '=') in the FOR Clause. Not sure whether I can use like variable >= field_name.
>
> Any help?
>
> J

Hi,

Try :

Locate for Between(YourVariable,MinValue,MaxValue)
Do While FOUND()

* your code

    Continue
EndDo


I hope this help :-)

Handi Rusli
"Treat people with respect and courtesy, and one will be blessed. Complete task heartily, with best effort and responsibility, and one can achieve the greatest."

COMPLETE THREAD

LOCATE command in VFP Posted by Joriveek Joriveek @ 2/6/2003 10:55:49 AM
RE: LOCATE command in VFP Posted by Handi Rusli @ 2/6/2003 11:05:32 AM
RE: LOCATE command in VFP Posted by Joriveek Joriveek @ 2/6/2003 11:28:56 AM