Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL view with parameter
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
SQL view with parameter
Divers
Thread ID:
00799168
Message ID:
00799168
Vues:
62
Hi,
I'm just wondering about where to put a SQL view (named Vdemo). I can design it in SQL server and use it with just "select * from Vdemo" in VFP. Or I can write the often complex select-sentence in VFP using SQLEXEC(), remote view or have it in a cursor-adapter. But what if I want to add a parameter? Will a "Select * from Vdemo where field=?value" use the filter on the server or will the whole cursor be transferred before the filter is adapted?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform