Solved

Project Compare Program?

Posted on 2010-09-03
4
350 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Always backup Domain, SYSVOL etc.using processes according to Microsoft Best Practices. This is meant as a disaster recovery process for small environments that did not implement backup processes and did not run a secondary domain controller that ne…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 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