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:05:11
Tore Bleken (Online)
Vear, Norway
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Parameterized views, but want to override in design mode
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01219655
Message ID:
01219660
Views:
12
Hi Tore

>Where .T.

Thanks for your quick reply. I already have a WHERE clause as below:
WHERE COALESCE(TPACKINGLIST.IPKLNO, 0) != 0 ;
		OR TPACKINGLIST.IID = ?VP_IID ;
How do I fit in the .T.. From the top of my head if I do an OR .T. the view will always return all records.

UPDATE: This is from a remote view thus the COALESCE else it would have been EVL
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