Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing parameters to a view...
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00438784
Message ID:
00438894
Views:
14
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform