Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select as logical in SQL statement
Message
From
12/07/2016 08:12:55
Tamar Granor
Tomorrow's Solutions, Llc
Elkins Park, Pennsylvania, United States
 
 
To
11/07/2016 16:08:38
John Mc Adam
Houston, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Select as logical in SQL statement
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01638232
Message ID:
01638257
Views:
100
>Thanks Hugo - got me on the right path!
>
>This works:
>
CAST(.f. AS L) as xyz
(or .t. if you want the opposite)

You don't need CAST there. Just using .F. or .T. gives you a logical field.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform