Where is FoxPro??

[fsuorange2]

I have VS.Net and heard that Visual FoxPro is included on one of the installation cds. I tried to find in it on the 1st cd but cannot. Where is it. How do i install Visual FoxPro?

[stustarz]

Are you sure you dont mean Visual Studio 6 or less, fox pro doesnt have a .NET version (yet!)

[Diesel]

Im sorry to tell you, but no one uses FoxPro anymore.

[coldfusion244]

Im sorry to tell you' date=' but no one uses FoxPro anymore.[/quote']

 

What was it used for in the first place?

[fsuorange2]

Im sorry to tell you' date=' but no one uses FoxPro anymore.[/quote']

 

 

why?

version 9 was just released. Should I get Access or FoxPro? I thought Foxpro was better.

Edited March 1, 2005 by fsuorange2

[stustarz]

Well foxpro doesnt really compare to access as such, they have two completely different functions. FoxPro is a programming tool, with a native database. Access is just a database, yes - access has VBA, you can program it to a certain extent but its not meant for redistribution or application creation - foxpro was made to allow developers to create applications that use a database without having to contend with external datasources. Unfortunately i dont think it really caught on...

 

If your looking simply to get a database solution, for your use then yeah go with access, for something much much more robust and capable for 'real world' usage then go with SQL Server. In terms of application development then .NET is the way (wouldnt be here if i didnt think this :) ) VB, C#, C++ the choice is yours

[michael_hk]

Im sorry to tell you' date=' but no one uses FoxPro anymore.[/quote']

I know many companies, including large insurance companies, still using FoxPro.

[Nerseus]

FoxPro is definitely still in use! But, if you have no requirement to use it and not familiar with it, I would start with Access. If you feel you're not so "junior", mySql or MSDE (harder to setup but more robust than Access) might suit your needs more but Access works for many small projects.

 

SQL Server is always an option, but it's very pricey. There is a free version if you're just writing test code.

 

This doesn't really answer what you want - how to get FoxPro. From what I recall, it came with Visual Studio 6 (mentioned above) but not with .NET.

 

-ner

[fsuorange2]

i ordered foxpro anyways. from the trial version even though the ui is messed up compared to access it looks more powerful than access. i can't afford sql server so thats why i went with foxpro. can u use msde natively even though it doesn't have a ui?

[Nerseus]

If you want to use MSDE, be prepared to read quite a bit of the README that comes with it. Its install is command line based and if you want a secure password or if you want to turn off network support (so people on the internet can't see your copy) and other options, you need to read and set some options.

 

I use MSDE at home for my little projects. I use the Express version of Visual Studio (for C#, still in beta). It has a Server Explorer piece that allows creating database, tables, columns, etc. It works well enough for me but my needs are small.

 

There's also MySql, which is free (I think). I've never tried it, but I know it's fairly popular and well supported - it might be a better alternative to FoxPro as well.

 

I haven't checked recently, but MS does phase out some products. You might check on FoxPro just to make sure you don't spend too much time learning it only to find it's being removed from MS's support.

 

While SQL is mostly the same, every DB engine has slightly different syntax. For example, to get the first 10 rows in SQL Server:

SELECT TOP 10 * FROM Table1

 

In MySql:

SELECT * FROM Table1 LIMIT 10

(or something like that)

 

FoxPro probably has its own special syntax...

 

Have fun!

 

-ner

[coldfusion244]

MySQL is free, the support though isn't. Here is a link to the online manual FYI http://dev.mysql.com/doc/mysql/en/sorting-rows.html

[michael_hk]

MySQL is free, the support though isn't.

If you have problems related to MySQL, you can easily get help from the MySQL forums on the net. So you probably don't need support for small issues.

[fsuorange2]

i thought if u use MySql for commercial apps (ones you are planning to sell) you had to pay. Is this correct?

[michael_hk]

i thought if u use MySql for commercial apps (ones you are planning to sell) you had to pay. Is this correct?

Yes, if I remember correctly. :)

[pas30339]

 

I use MSDE at home for my little projects. I use the Express version of Visual Studio (for C#, still in beta). It has a Server Explorer piece that allows creating database, tables, columns, etc. It works well enough for me but my needs are small.

 

What has been your experience in deploying MSDE with your applications? The MSDN documentation gives the impression it's pretty strait forward but I've heard nothing but horror stories from those that have actually done it. I ask because I need to deploy MSDE with an application I am developing and I'm just starting the research on packaging it with the installation.