Bob Lee <> wrote this on Thursday, June 30, 2005 9:20 AM:
> I have been using MySql with VFP for a few years, and for many
> reason I
> have never thought about changing to ms sql.
> But.. times do change. - and the two products seem to be coming
> closer
> together.
> Mysql is at some point going to have stored procedures and views.
> SqlServer Express doesn't limit the number of users.. and from what I
> read
> you can use it on the internet, without paying the license fees.
>
> I would love to have created an application which is database
> independent.
> where all one has to do is configure the client application, and
> install the
> database on a mysql server or mssql server.... (depending on your
> political
> views) and the vfp application just runs.
> So that is why I am tinkering with mssql express.
Getting typed data, and having all your add, edit, delete (s) run through
SP's are great. You don't have to change client code nearly as much when
you can just change the SP. Having a view that puts allot of the joins
together for you is also great.
Stephen Russell
S.R. & Associates
Memphis, TN 38115
901.246-0159
http://spaces.msn.com/members/srussell/
©2005 Stephen the Cook |
