Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to change the FILTER of the View
Message
From
18/11/2005 22:02:46
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to change the FILTER of the View
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01070459
Message ID:
01070459
Views:
56
Hi,
I have a view of client table (client_v) which have following FILTER
SELECT Client.customerid, Client.ecompnam FROM ;
     kamyip!client;
 WHERE  Client.salesmanid = ( ?psalesmanid );
   AND  Client.bussid = ( ?pbussid )
Now I want to change the Filter of the client_v at runtime by adding
one more parameters to the query, how can I change it by coding ?

Please advise.
Thanks.
Derek Yim
Next
Reply
Map
View

Click here to load this message in the networking platform