FoxPro Setup - Questions for VFP

Author

Questions for VFP

CrazyDay

2005-05-05, 3:24 am

Dear all,

I would like to ask some questions about VFP. (I am considering to upgrade
to VFP9.0)
1). Can I use build wizard to upgrade my VFP3.0 to VFP9.0 directly?
2). Which specification of a PC performs better for VFP9.0?
3). Any problem discovered for VFP9.0?
4). Which one (VFP or Oracle) is better when I am talking about the data
volume of a million records? (My friend told me that Oracle is better for
handling a big volume of data when performing like enquiry. Why?)
5). Any problem for changing from LPT to network printer? Actually I used to
be using generic text only printer driver under dot matrix printer...
6). Based upon the stability, VFP6.0, 7.0, 8.0 or 9.0, which one is better?
(I am thinking to buy VFP9.0)
7). Any documents for helping me to develop a VFP program + Oracle database?
(Just in case VFP database doesn't perform well)
8). Any documents for helping me to develop Web-based application + VFP
database?
9). Any license needed for the users when I build a new application for
them? (I have one develper license and only I use it to build a new
application)

Craig Berntson

2005-05-05, 9:24 am

See my answers below:

--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net

"CrazyDay" <tsan7@hotmail.com> wrote in message
news:8E4BB908-4DB1-4C1D-BB5F- E86BE2C1E5A9@microso
ft.com...
> Dear all,
>
> I would like to ask some questions about VFP. (I am considering to upgrade
> to VFP9.0)
> 1). Can I use build wizard to upgrade my VFP3.0 to VFP9.0 directly?

Yes. There will be a few issues as some behavior has changed, but it should
be easy to fix.

> 2). Which specification of a PC performs better for VFP9.0?

IDE works only on Win2K, XP, and 2003. Runtimes also are supported on 98.

> 3). Any problem discovered for VFP9.0?

Yes, but not many.

> 4). Which one (VFP or Oracle) is better when I am talking about the data
> volume of a million records? (My friend told me that Oracle is better for
> handling a big volume of data when performing like enquiry. Why?)

VFP can easily handle a million records. I've had tables with 11 million
records and VFP kept chugging along.

> 5). Any problem for changing from LPT to network printer? Actually I used
> to
> be using generic text only printer driver under dot matrix printer...

VFP uses Windows printing services, so there should be no problems.

> 6). Based upon the stability, VFP6.0, 7.0, 8.0 or 9.0, which one is
> better?
> (I am thinking to buy VFP9.0)

Definately VFP 9.0.

> 7). Any documents for helping me to develop a VFP program + Oracle
> database?
> (Just in case VFP database doesn't perform well)

Performance is not a reason to move from VFP to Oracle. Security, huge data
sets, corporate policies, and remote access are reasons to move, but not
performance. Like any tool, you have to make sure you use VFP right to get
the performance you want.

> 8). Any documents for helping me to develop Web-based application + VFP
> database?

Lots of information at www.west-wind.com and a couple of books at
www.hentzenwereke.com

> 9). Any license needed for the users when I build a new application for
> them? (I have one develper license and only I use it to build a new
> application)

No runtime license or fees are required.

Cindy Winegarden

2005-05-09, 7:24 am

Hi Crazy,

In addition to what Craig said, you could also consider Microsoft SQL Server
or the "lite" (free) version: MSDE, which is free but limited to 2GB per
database. SQL 2005's "lite" version, SQL Server Express will have a limit of
4gb.

Microsoft SQL Server may be less expensive than Oracle if you're going that
route.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

"CrazyDay" <tsan7@hotmail.com> wrote in message
news:8E4BB908-4DB1-4C1D-BB5F- E86BE2C1E5A9@microso
ft.com...

> 4). Which one (VFP or Oracle) is better when I am talking about the data
> volume of a million records? (My friend told me that Oracle is better for
> handling a big volume of data when performing like enquiry. Why?)

Fergus

2005-05-10, 7:24 am

CrazyDay wrote:
> 3). Any problem discovered for VFP9.0?
> 9). Any license needed for the users when I build a new application for
> them? (I have one develper license and only I use it to build a new
> application)

Be aware, that applications compiled with VFP9.0 will not run under NT4.
VFP8 compiled applications run on NT/2000/XP/2003 applications.

Fergus.

Craig Berntson

2005-05-10, 9:24 am

That's not quite right. Runtimes will run on Win98, and Me and I think on
NT4, SP6. The development IDE will only run on NT/2000/XP/2003.

--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net

"Fergus" <Fergus@NOSPAM.mason.co.uk> wrote in message
news:%23Co4MeVVFHA.628@TK2MSFTNGP09.phx.gbl...
> CrazyDay wrote:
>
> Be aware, that applications compiled with VFP9.0 will not run under NT4.
> VFP8 compiled applications run on NT/2000/XP/2003 applications.
>
> Fergus.

Fergus

2005-05-12, 7:24 am

Craig Berntson wrote:
> That's not quite right. Runtimes will run on Win98, and Me and I think on
> NT4, SP6. The development IDE will only run on NT/2000/XP/2003.
>

Craig, my point was that VFP9 "Runtimes" definately do NOT work on NT,
where as VFP8's do.

Also, developement IDE for VFP9 only runs on 2000/XP/2003, and not on NT
as you state.

Fergus.

Sponsored Links