Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logical fields
Message
From
27/10/2005 16:29:43
 
 
To
27/10/2005 12:09:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP3
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01062663
Message ID:
01062776
Views:
17
>hi i've a big proble i wich make union to 2 fields logicals how i make this example.
>
>field a l
>field b l
>
>select a+b from table1
>
>but that instruction make a proble . tks.

What is it you're trying to do? Combine the fields? Or are you trying to return a record if either field is true?
SELECT IIF(a,"T","F")+IIF(b,"T","F") FROM table1
SELECT a,b FROM table1 WHERE a OR b
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform