Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to change the FILTER of the View
Message
De
18/11/2005 22:02:46
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How to change the FILTER of the View
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01070459
Message ID:
01070459
Vues:
55
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform