Solved

Project Compare Program?

Posted on 2010-09-03
4
315 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
  • 2
4 Comments
 
LVL 41

Expert Comment

by:pcelba
Comment Utility
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
Comment Utility
...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
Comment Utility
source code control is the general name, not source versioning, sorrry.
0
 

Author Closing Comment

by:fmoore0001
Comment Utility
Thanks, Olaf.  This is the path we took.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
HOW TO: Install and Configure VMware vSphere Hypervisor 6.5 (ESXi 6.5), Step by Step Tutorial with screenshots. From Download, Checking Media, to Completed Installation.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now