>We are thinking about moving the database from VFP to SQL server and keep the VFP as frontend and develop client-server application using Red Matrix's DataClas. Or should we instead use VFP remote views or SPT?
>Any comment?I've never uses DataClas so I can't comment on it, but it probably will do what you need. Other options are VFP's CursorAdapter, or SPT which work very well.
Most VFP available OOP Frameworks also have facilities and classes to easily manage SQL Server connections.
Or you can use wwSQL class from Rick Strahl (
http://www.west-wind.com/webconnection/docs/_S8X03TCFS.htm). Or Andy's & Marcia's (
http://www.tightlinecomputers.com/Downloads.htm) data connection classes.
See also:
http://fox.wikis.com/wc.dll?Wiki~CategoryClient/ServerThere are plenty of options available to you.