Link to home
Start Free TrialLog in
Avatar of Peterson50
Peterson50Flag for United States of America

asked on

Language to rewrite FoxPro program

I have a client who wants me to rewrite an old FoxPro program (extremely simple) so that his company can still utilize it.  It is so old, of course it is using the standard Dbase syntax (set defa on, set prg to .T. etc etc)

It only consists of 2 tables with relationship.  I was famaliar with programming in this years ago and am curious if anyone can recommend something that I can use to rewrite it that does not require a very large programming time and is able to read and write dbase tables.
I see that they have Dbase for Windows but don't know if it is any good.

Anyone have any ideas (its been years since I have done any programming ) but Dbase I'm still familiar with (not that I have used it in a while but syntax still comes back)

Needs to be multi-user as it is used in a warehouse to track inventory movements (currently they run it in virtual box ) but would like to run it natively on Windows 7 as they are preparing for upgrades.
Thanks
ASKER CERTIFIED SOLUTION
Avatar of Olaf Doschke
Olaf Doschke
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I've just 'converted' a complex dBase program and found the large majority of it went across to Visual Foxpro with little problem. VFP has a lot of backward compatible features and supports basic dBase 2/3/foxpro syntax (for which the documentaton is dire - you often have to get the help text from earlier versions) but it works fine - or at least did for me.
Avatar of Peterson50

ASKER

I thought VFP was discontinued, where can I get it from?  Will it run on Windows 7 64bit?
Any other language that is compatible with it where I do not have to rewrite a lot of code.


Paul
Microsoft SQL Server would be relatively cheap, moderately scalable, and extremely easy to convert.

If you want more scalability, DB2 or Oracle would be your best bet. But, for just a couple tables, SQL Server will do the trick magnificently.

HTH,
DaveSlash
VFP is discontinued. I had access to a copy.

You could try Dbase Plus. That is a package under current development that supports the classic dBase syntax and files. (see www.dbase.com). It has some facilities to support conversion from old dBase code to modern object oriented windows based stuff but when I looked at it the conversion was too complicated.- (but I did have 30k lines of code, 8 dbs and 14 indexes with actual DOS 'windows')
Unless you have lots of complex reports/screens/processing logic it is almost certainly better to re-write and take the users through the learning curve.
It compiles in 32-bit and can run on Windows 7 64-bit.

You take the source code do minor enhancements to Forms and Reports and make sure that the temporary files and data are in place for Vista/7 recommendations or just move them to a standalone folder outside Program Files.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hhhmmm - I don't think ANY new language - even if the syntax is familiar - is 'easy'. Least that was my view after the dBase ->VFP. Possible, even practical but not easy!!

But on reflection most of my problems arose from the old fixed font used in DOS and the fact that the DOS dBase program had actual windows - which proved tricky. If you stay with the basic xBase syntax it should be pretty much ok
You can also check FoxInCloud. Your FoxPro application can have another life in the Cloud :).

http://www.foxincloud.com/
Actually Olaf it is easy to rewrite, It looks like it is between visual foxpro or Dbase, Visual Fox Pro would have less of a learning curve for me..  I don't have MSDN subscription, I'm assuming the one I need is the Video Studio Professional which runs 1199.00, that's why I'm was trying to see if I can purchase it from somewhere.

The Dbase 8 may have a steeper learning curve, trying to get this done quickly with familiar tools so would rather get Foxpro according to suggestions. Anyone know where I can buy it outright besides msdn
Boxed Visual FoxPro 9 is available at eBay sometimes.

If you prefer new copy then OLP version is the only option (from Microsoft or distributors). To qualify for OLP you have to buy 5 licenses of "something" i.e. 1x VFP 9 (product No. 340-01244) + 4x  66J-05385 ($10 each).

More details are here: https://www.experts-exchange.com/questions/28149093/Visual-Foxpro-9-0-purchase.html
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I don't know if that works, pavel. I downloaded the full list of products available through the license program and VFP is not listed for 2013. It's of course the cheapest solution to buy VFP from MS directly, if that works.

Bye, Olaf.
Avatar of rinfo
rinfo

I would suggest Delphi 7 with Apollo database. You would find a lot of similarities over there and lots and lots of function which are alternative to whats there in foxpro.
If you mean VFP OLP license Olaf then it still works this way. VFP is still listed in CDW and in other stores as well.

I am just curious what will happen in 2015...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
VFP is not even listed among products removed from above lists in the past year...
I just did a Google search for:   purchase foxpro 9   and found a number of 'finds'

I didn't follow the links to see how many were still REAL, but I'd guess that some of them have copies for sale.

Good Luck
Interesting. The first two are not legal for sure. Neither the Russian one...

And the last one is legal but out of stock already...

You have to search for FoxPro PartNo:  340-01244  and many relevant results will appear.

This link is also interesting: http://www.baiyujia.com/ 
They are working on FoxPro add-ons but they are also providing unofficial VFP 9 patches... And if I am not mistaken their download contains several VFP versions.