Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server view approach - advice needed
Message
De
23/03/2015 05:00:43
 
 
À
21/03/2015 21:19:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01617042
Message ID:
01617107
Vues:
34
Once you create views with a program, you can easily expand the number of parameters and/or the number of views depending on the various filtering scenarios.

Using a naming convention will help you find at runtime which view should be used in a given situation.

WRT FoxInCloud I'd recommend to USE all views NODATA at form.load(). Even if USEing dynamically is supported, monitoring is easier when all views are opened at form startup.

>Also a factor that the view parameters could change frequently as the user presses various filter combinations,
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/
Never explain, never complain (Queen Elizabeth II)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform