Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing parameters to a view...
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00438784
Message ID:
00438894
Vues:
16
>I have this complex SQL Select and I like to use it as view but I need to pass parameters in the condition.
>
>How can I pass parameters to a view?

If I understand correctly what you mean, use the question mark:

SELECT * FROM table WHERE field = ?m.cValue

VFP will replace ?m.cValue with the value of that variable when opening the view and issuing a REQUERY().

Is this what you're looking for?
Sylvain Demers
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform