Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Designer Question ( AND OR combo)
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00742533
Message ID:
00742536
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
>Question...

>I want to use the View Designer to create a view that goes like this....


>SELECT * FROM mydata WHERE condition_A AND ( condition_B OR condition_C )

>Can the View Designer create a view using the parenthesis?? Or will I have to do this using SQL-Passthrough???

You can do it programaticaly:
CREATE SQL VIEW AS ;
    SELECT * FROM myData ;
       WHERE condition_A AND ....
Of course, in VFP8 it will be more than easy.
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform