Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select
Message
De
06/08/2008 09:21:37
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
06/08/2008 03:27:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: Select
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01336783
Message ID:
01336844
Vues:
10
>hi all,
>
>i use this code below to find names i need to rewrit it .
>
>thanks for help
>
>
> SELECT F4,F1,name4,name3,name2,name1  from x2;
>              where  (name1==lcName and name2==lcName1 and name3==lcName2 and name4==lcName3) OR ( name4==lcName3) ;
>              ORDER by name1,name2,name3,name4;
>               into cursor crsMyCursor readwrite
>
>    &&IF ! FOUND()  OR EMPTY
>
>SELECT F4,F1,name4,name3,name2,name1  from x2;
>              where  ( name4==lcName3) ;  && shure found
>              ORDER by name1,name2,name3,name4;
>               into cursor crsMyCursor readwrite
>
>
For any question you ask, you should explain:
  • What do you want to achieve
  • If the code doesn't work, what is the error message; or what is the difference between the desired result, and the result you really get.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Précédent
    Suivant
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform