General discussion

Locked

compatibility of Foxpro 2.6 dos-based

By armando_santos ·
Can I migrate or whatever some programs written in Foxpro 2.6 Dos to some graphics-based version like Access...without changing the programs very much or do they all have to be rewritten.....this is a Foxpro 2.6 question====if I have a peer to peer network, do I have to lock the file when I am appending a new record or just when both computers may be trying to change the same record??

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

compatibility of Foxpro 2.6 dos-based

by ananthap In reply to compatibility of Foxpro 2 ...

For Q 1, will VFP do? FoxPro 2.5 for Windows does work. There are some tools out there.

For Q2. Yes. Even tho' the manual says that FoxPro does a file level lock for appends, the point to remember are the series of REPLace statemnts that must succeed the append blank. So better to put it in a while not lock loop.

Hope it helps.
end of mail.

Collapse -

compatibility of Foxpro 2.6 dos-based

by armando_santos In reply to compatibility of Foxpro 2 ...

The question was auto-closed by TechRepublic

Collapse -

compatibility of Foxpro 2.6 dos-based

by Dave Lingwood In reply to compatibility of Foxpro 2 ...

Armando:
If you leave FoxPRO you'll have to rewrite all the code. The quick and dirty solution is to get FoxPro 2.6 for Windows (you can probably find it used). It will run the DOS code correctly in a Windows environment (at least thru Windows 2000and probably XP). The screens will look scrunched up and, well, like DOS. If you have just a few screens you can quickly redesign them in FoxPro/Windows good forms designer.
I don't recommend Access -- it isn't as good at multi user work as SQL Server.
Best solution is to bypass any language that requires creating client software that must be compiled, distributed and updated -- go directly to a web-based solution using .ASP programs running in IIS and linking to a SQL Server database on the server. The data can be imported directly into SQL Server (you may have to tell MS SQL's import program that the tables are dBASE III). You'll find that SQL query syntax is familiar to what you've used in FoxPro.
That leaves the issues of development environment and web-based database handling.
I use MS Visual InterDev 6.0 for development, writing my server .ASP programs in VBScript (why?--because almost everyone does, and all the tutorials use it), and my client scripts in JavaScript (why?--because almost everyone does, and all the tutorials use it). Unfortunately, that means you have to learn a couple of languages, plus InterDev and SQL Server. Plan for at least a 6 mo. learning curve.
I found an invaluable tool to handle web databasesand the web pagesfor data entry and display. It is Generic DB. See
http://www.gene ricd b.com
(remove the spaces from the link above)
This is shareware with very reasonable price. It gives you all the code to bring up an SQL or Access table on the web, view and edit data, etc. I wrote a whole multi-table meta-data db system around it. It is also a good way to learn database handling in VBScript.
Good luck,
Dave

Collapse -

compatibility of Foxpro 2.6 dos-based

by armando_santos In reply to compatibility of Foxpro 2 ...

The question was auto-closed by TechRepublic

Collapse -

compatibility of Foxpro 2.6 dos-based

by armando_santos In reply to compatibility of Foxpro 2 ...

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums