>1. SQL pass-through is more flexible. You can easily create a query on the fly. With a view, you either have to use a parameterized view or create a temporary DBC, create a view, then open the view.
>

Well... you can define an SQL in the view with no where. Then you can open the View with NODATA. Grab the SQL and connection handle using cursorgetprop. Then you can do a SPT with the query using the connection of the view to a cursor using NOFILTER. No, append this to the view.

The above, while it would be better if MS allows us to define the WHERE of a view on the fly... allows that... The advantage is, you can maintain the fields selected and the joins in the view. Also, you can define all the updateable fields and such. Seems to work for my at times. It is the best combination of a View and SPT.


>2. SQL pass-through is a little bit faster. In my experience, a properly configured view is almost as fast, so it's not a huge issue.
>

Since a View IS a SPT the speed should be about the same.

>3. Views usually stop working if any changes are made to the database.

This is a maintenance issue, and not a reason to use SPT over views.

BOb