Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select
Message
From
06/08/2008 09:21:37
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
06/08/2008 03:27:51
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Select
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01336783
Message ID:
01336844
Views:
9
>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)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform