Kent, In my humble opinion, the big problem with remote views is that they are held as part of your database and as such if the data in the base table changes then the dbc has to be updated accordingly. You would be far better using either SQL Pass through cursors (my choice) or cursor adaptors, which are similar to views but suffer from the same deficiencies. Some people swear by views but I have been bitten by them in the past.... especially in mulkti user envoronments when you can't update the view in the database as you need exclusive access .... Grrr. Cursor Adapters are the easy compromise if you want minimum programming and you can even use them visually in the designer if you create them first. Just be careful to set up the parameters for access etc.
I think you will find Mike is an SAP advocate as are many on here. They are more flexible, allow you to have completely disconnected data sets and fall easily into creating classes for Business objects where they form the Data Layer. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Kent Belan Sent: 15 July 2014 00:28 To: 'ProFox Email List' Subject: VFP9 Views 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 [excessive quoting removed by server] _______________________________________________ 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.
