SQL Server doesn't support parameterized views in the same fashion that VFP does.
You can get similar functionality using stored procedures, but the result set will not be updatable.
IMO, you should use stored procedures for all of your data access. Call a stored proc to retrieve the data that you need and call another one to update the data when you want to make a change.
-Mike
>Until now, I´ve been using parameterized updatable views to retrieve, edit and update records from some tables.
>
>Let`s say, in a form with a grid, the grid is bounded to a view, so I only have to "requery" the view to retrieve data, and "tableupdate" the view to get records inserted, updated and deleted in the related table(s).
>
>Now, I`m facing my first project using SQL-Server as a data Back end and my question are:
>
>How (if possible) do I get the same functionality described above?
>
>Are SQL-Server views updatable and "parameterizable"?
>
>How do I get the base table(s) of a view updated from changes made to the view?
>
>TIA.
>
>Cristóbal.