Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate for more than one record
Message
From
11/03/2002 20:54:33
Jonathan Cochran
Alion Science and Technology
Maryland, United States
 
 
To
11/03/2002 20:35:24
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00631289
Message ID:
00631298
Views:
23
How about:
ll_Found = .F.
Select table
Locate for fieldname1 = Myvalue1 and fieldname2 = Myvalue2
If found()
   Locate for fieldname1 = Myvalue3 and fieldname2 = Myvalue4
   If found()
      Locate for fiedlname1 = Myvalue5 and fieldname2 = Myvalue6
      If found()
         ll_Found = .T.
      endif
   endif
endif

If ll_Found
   = Messagebox("It is successfuly!",0,"Found")
endif
>Hi,all
> I want to find the three record in one table.If they are found,the message
>box is appeared that it is successfully.
>e.g.
>Select table
>Locate for fieldname1 = Myvalue1 and fieldname2 = Myvalue2
>Locate for fieldname1 = Myvalue3 and fieldname2 = Myvalue4
>Locate for fiedlname1 = Myvalue5 and fieldname2 = Myvalue6
>If found()
> = Messagebox("It is successfuly!",0,"Found")
>endif
>??? Please tell me!!
>Thank you
Previous
Reply
Map
View

Click here to load this message in the networking platform