Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized views, but want to override in design mode
Message
 
À
25/04/2007 03:40:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01219655
Message ID:
01219669
Vues:
9
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
___________________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform