>>Thanks, that helps!
>>
>>The one question I had though was about Views and indexes. My app opens tables and sets indexes. Can I just replace all my references to tables (USE MyTable) with Views (USE MyView) ?
>>
>>If so, how do I allow my app to set indexes on Views ? (SET ORDER TO TAG..)
>>
>>Or is this the totally wrong way to do it ?
>>
>>I probably should have originally designed the app with views, but at that point SQL Server was something I had no designs on tackling.
>
>You should probably create your views in the order you want to see them. That way there is no need to SET ORDER. You can create indexes on views if you need to, though, but that will have to be done after the view is opened.


Pardon Me For Jumping In. I just left (or it left me) a company where the front-end app was VFP 6.0 and back-end was SQL Server. We used remote views for data entry. Reports used Sql PassThrough. Once we upgraded to SQL Server 7.0 alot of the speed and stability issues were solved. We ended up with a ton of remote views but it was faster in the long run than to try and index the views.

We created the tables on the SQL Server and used a program that was based on the output from GENDBC.PRG (under sys(2004)+"\tools\gendbc") to recreate the DBC. After the program was created, we just made teh changes to the SQL Server tables and to the code in the program. Than we ran the program to create the new DBC. In the setup of the application we use the program to create the DBC on the individual workstation so we don't have to ship out alot files in the setup process.

Hope this helps.