>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