Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized views, but want to override in design mode
Message
 
To
25/04/2007 03:40:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01219655
Message ID:
01219669
Views:
10
Hi Tore

>You can do this in many ways. One possibility is to create a file ALLRECORDS.YES on your machine, and add something like this
>#IF FILE("ALLRECORDS.YES")
>  #DEFINE ALLRECORDS .T.
>#ELSE
>  #DEFINE ALLRECORDS .F.
>#ENDIF
>Your select will then be:
>WHERE ALLRECORDS or (COALESCE(TPACKINGLIST.IPKLNO, 0) != 0 ;
>		OR TPACKINGLIST.IID = ?VP_IID)
Thanks Tore, I like the idea. However, one more thing, how will I get in the # commands into the view?
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform