Link to home
Start Free TrialLog in
Avatar of fmoore0001
fmoore0001

asked on

Project Compare Program?

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.
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

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.
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
source code control is the general name, not source versioning, sorrry.
Avatar of fmoore0001
fmoore0001

ASKER

Thanks, Olaf.  This is the path we took.