Solved

Project Compare Program?

Posted on 2010-09-03
4
359 Views
Last Modified: 2012-05-10
Guys, does anyone know of a utility to compare two Foxpro project files?

Mostly, I am looking for an automated way to check to see the differences in file names in two products.
0
Comment
Question by:fmoore0001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 42

Expert Comment

by:pcelba
ID: 33594720
Projects are just DBF tables and you may create following query to check for filename differences:

USE Project1.PJX
USE Project2.PJX IN 0

SELECT LEFT(name, 80) FileName, type  FROM Project1 WHERE name NOT in (SELECT name FROM Project2)

SELECT LEFT(name, 80) FileName, type  FROM Project2 WHERE name NOT in (SELECT name FROM Project1)

If you are interested in filename without path, use JUSTFNAME() function:

SELECT LEFT(JUSTFNAME(name), 80) FileName, type  FROM Project2 WHERE name NOT in (SELECT JUSTFNAME(name) FROM Project1)

etc.
0
 
LVL 29

Accepted Solution

by:
Olaf Doschke earned 500 total points
ID: 33595271
...to see the differences in file names in two products....

Hmm, same names does not mean same version and perhaps even not same classes. Such a project comparison is of limited use. If you aim towards project source versioning, you can use Visual Source Safe with foxpro, which is outdated but would still work.

http://fox.wikis.com/wc.dll?Wiki~VisualSourcesafeIntegration

The general goal of a source versioning integration is to maintain a project and be able to work on it in a team of developers, also keep certain versions eg stable production, beta, development. All this without independant scattered copies but a central repository of the project files, which also holds information about who has checked out files for what reasons and what changes have been made for what reasons when the changes are check in again.

Bye, Olaf.
0
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 33595279
source code control is the general name, not source versioning, sorrry.
0
 

Author Closing Comment

by:fmoore0001
ID: 33623788
Thanks, Olaf.  This is the path we took.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Part One of the two-part Q&A series with MalwareTech.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

634 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question