Hello, I am trying to convert a VFP9 app to work with SQL and so far it is going ok.
I have used West-Wind business objects to talk to the SQL server and that is working great for the transaction tables. Now I need to get the client tables moved over to SQL. This app has many different groups and each group has its own client.dbf so it is real easy to open a table and only be working with the clients in that group only. I think I want to use REMOTE VIEWS to get the client tables to talk to the SQL server. I know very little about views and from what I have been reading, I won't have to make any changes to the code as far as seek and replace commands go if I use a view. Is this true ??? Does anyone have some sample code to share that would show how to build the view and activate it for use ? Thanks, Kent _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

