Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate for more than one record
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00631289
Message ID:
00633762
Views:
14
>------------->>> your message
>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
>
>
>-------------->>> My soultion
>** Try using this code:
>select table
>locate for inlist(fielname1,myvalue1,myvalue3,myvalue5) and ;
> inlist(fielname2,myvalue2,myvalue4,myvalue6)
>if found()
> = Messagebox("It is successfuly!",0,"Found")
>endif
>
>Hope this could be help

No, it woudn't. See Message #631891.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform