Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Locate for more than one record
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00631289
Message ID:
00633762
Vues:
15
>------------->>> 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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform