Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate for more than one record
Message
 
To
11/03/2002 20:42:45
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00631289
Message ID:
00631318
Views:
24
>
>SELECT * FROM mytable ;
>WHERE (fieldname1 = Myvalue1 and fieldname2 = Myvalue2) AND ;
>(fieldname1 = Myvalue3 and fieldname2 = Myvalue4) AND ;
>fiedlname1 = Myvalue5 and fieldname2 = Myvalue6 ;
>INTO CURSOR mycursor
>
>IF _TALLY > 0
>   MESSAGEBOX("SUCCESS!")
>ELSE
>  *--DO WATEVER
>ENDIF
>
>
This select will find no records ever because fieldname1 will never equal MyValue1 and MyValue3 for any one record.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform