Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create a cursor with predefined structure
Message
From
02/10/2001 10:10:26
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
02/10/2001 10:04:26
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00562758
Message ID:
00562986
Views:
22
>>>
>>>
>>>select * from myTable where 1=0
>>>
>>>
>>>Will that work?
>>
>>You can also do:
>>
>>
>>Select * From myTable Where .F.
>>
>>
>>Renoir
>
>Or,
>
>select * from mytable where "YES"="NO"
>
>This would be the slowest version. *grin*

LOL!

Hmmmm... How about:
select * from mytable where Alltrim(Str(Val(IIF("YES",1,0)))) = Alltrim(Str(Val(IIF("NO",0,1))))
Renoir
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform