Hi Gary!
I'm no expert with client/server, but what I currently do is that I use parametered views for all tables that I will be updating. I also sometimes have views for simple lookup queries.
I always use SPT (SQL PassThrough) when it's something that can't be done via the views (duh!), such as calling stored procedures or SELECT statements that don't rely on tables (such as "SELECT @@IDENTITY"). I will also sometimes use SPT for queries that the view designer chokes on (such as having 4 or 5 LEFT OUTER JOINs), but it would probably be better to have stored procedures for those situation.
So I'm mostly using views.
Hope this helps!
Sylvain in Frosty Val d'Or! :)
>We have just installed our first SQL Server and plan to migrate current VFP applications.
>Can someone provide me with a resource or suggestions on when to use remote views and when to use SQL Passthrough
>
>
>Thanks
>Gary in Cloudy Dallas
Sylvain Demers