I am about to develop two applications for a government agency using SQL Server as the backend. I am wondering if it is a good idea to use Visual FoxPro 9 as the frontend. Is it stiil relevant?
Carol,
Well as you might expect, most people here would say YES! Hooking on to data in SQL server is easy enough and you even have a number of choices - Views, Cursor Adapters, Pass Though - ODBC, ADO - OLE DB.
With VFP 9.0's enhanced SQL data compatibility - through new data types, commands and functions - it's much easier than even in pre 9.0 (which was still easy!).
It is quite relavant - especially when the you hear highly placed MS employees talk about how VS.NET will be "borrowing" more of VFP to include in future versions (learn it here now!). See the last 3-4 minutes of this Channel 9 interview of Ken Levy -
Given that you are using a SQL Server back end, there is one overriding advantage of VFP 9.0: it supports the varchar data type. This seemingly small improvement makes a world of difference when using remote views to update the back-end.
Even without all the other many benefits of the new release, the support for varchars justifies the cost of upgrading.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.