I was wondering if anybody new of a Table Comparison utility. I wrote a Fox2x utility a while back that compares two folders and generates reports on structure & index differences (i.e. Filename, Field Name, Field Type, Field Width, Error, where Error could be Field not found in Source or Field Width not equal, etc.). It doesn't work for VFP Tables as of yet and don't have time to debug it as I'm working on a deadline.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
There are a couple in the Leafe.com downloads section.
Thanks Alan, I was able to get CompTabs to work by Stephen Weeks after a few tweaks.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, February 10, 2016 11:39 AM To: profoxtech@leafe.com Subject: Re: DBF Compare
There are a couple in the Leafe.com downloads section.
Hi Richard, Care to share the tweaks and I can build them into teh original and upload again, I use this facility regularly to make comparisons and table alterations.
On Wed, 10 Feb 2016, at 05:40 PM, Richard Caruso wrote:
Thanks Alan, I was able to get CompTabs to work by Stephen Weeks after a few tweaks.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, February 10, 2016 11:39 AM To: profoxtech@leafe.com Subject: Re: DBF Compare
There are a couple in the Leafe.com downloads section.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Sure. It may have something to do with comparing data on mapped drives, but not sure. When I moved the two data folders and the exe to the C Drive, it worked great. I could snap a screen shot of the debugger at the state in which it errors, but I can't recall what upload site profox users use for image URLs. If anyone can let me know that would be great.
The error is "Invalid path or file name" on line CD "&LAUNCHDIR" in container1 click method.
IF !EMPTY(THISFORM.text1.VALUE) LAUNCHDIR=CURDIR() SDir=CHR(34)+ALLTRIM(THISFORM.TEXT1.VALUE)+CHR(34) CD &sDir MAXFILES=ADIR(FLSARR,'*.DBF') THISFORM.COMBO1.REQUERY --> CD "&LAUNCHDIR" ENDIF
LAUNCHDIR = "\COMPARES\COMPTABS" sdir = "S:\DATA\TI_DATA\185\EPCTDATA"
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Weeks Sent: Wednesday, February 10, 2016 4:09 PM To: profox@leafe.com; profoxtech@leafe.com Subject: Re: DBF Compare
Hi Richard, Care to share the tweaks and I can build them into teh original and upload again, I use this facility regularly to make comparisons and table alterations.
On Wed, 10 Feb 2016, at 05:40 PM, Richard Caruso wrote:
Thanks Alan, I was able to get CompTabs to work by Stephen Weeks after a few tweaks.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, February 10, 2016 11:39 AM To: profoxtech@leafe.com Subject: Re: DBF Compare
There are a couple in the Leafe.com downloads section.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Hi Richard,
I think i get the problem, I always compare tables between the source code on my c drive and the mapped drive to the server, never from one mapped drive to another.
Perhaps LAUNCHDIR should be set to sys(5)+sys(2003) instead of curdir() ?
I will check this ... thanks !
On Thu, 11 Feb 2016, at 08:59 PM, Richard Caruso wrote:
Sure. It may have something to do with comparing data on mapped drives, but not sure. When I moved the two data folders and the exe to the C Drive, it worked great. I could snap a screen shot of the debugger at the state in which it errors, but I can't recall what upload site profox users use for image URLs. If anyone can let me know that would be great.
The error is "Invalid path or file name" on line CD "&LAUNCHDIR" in container1 click method.
IF !EMPTY(THISFORM.text1.VALUE) LAUNCHDIR=CURDIR() SDir=CHR(34)+ALLTRIM(THISFORM.TEXT1.VALUE)+CHR(34) CD &sDir MAXFILES=ADIR(FLSARR,'*.DBF') THISFORM.COMBO1.REQUERY --> CD "&LAUNCHDIR" ENDIF
LAUNCHDIR = "\COMPARES\COMPTABS" sdir = "S:\DATA\TI_DATA\185\EPCTDATA"
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Weeks Sent: Wednesday, February 10, 2016 4:09 PM To: profox@leafe.com; profoxtech@leafe.com Subject: Re: DBF Compare
Hi Richard, Care to share the tweaks and I can build them into teh original and upload again, I use this facility regularly to make comparisons and table alterations.
On Wed, 10 Feb 2016, at 05:40 PM, Richard Caruso wrote:
Thanks Alan, I was able to get CompTabs to work by Stephen Weeks after a few tweaks.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, February 10, 2016 11:39 AM To: profoxtech@leafe.com Subject: Re: DBF Compare
There are a couple in the Leafe.com downloads section.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Richard Caruso wrote on 2016-02-11:
Sure. It may have something to do with comparing data on mapped drives,
but
not sure. When I moved the two data folders and the exe to the C Drive,
it
worked great. I could snap a screen shot of the debugger at the state in which it errors, but I can't recall what upload site profox users use for image URLs. If anyone can let me know that would be great.
The error is "Invalid path or file name" on line CD "&LAUNCHDIR" in container1 click method.
IF !EMPTY(THISFORM.text1.VALUE) LAUNCHDIR=CURDIR() SDir=CHR(34)+ALLTRIM(THISFORM.TEXT1.VALUE)+CHR(34) CD &sDir MAXFILES=ADIR(FLSARR,'*.DBF') THISFORM.COMBO1.REQUERY --> CD "&LAUNCHDIR" ENDIF
LAUNCHDIR = "\COMPARES\COMPTABS" sdir = "S:\DATA\TI_DATA\185\EPCTDATA"
Richard,
Seeing the value of LaunchDir, one thing VFP does when it CD's into a directory ( SET DEFAULT TO also) is reads the folder above it to verify the folder you are heading to exists. I had a lot of trouble with some customers for a while.
If you were to CD to a folder below the Share "\COMPARES\COMPTABS\workingfolder" you would have better success. Some of our customers noticed a performance increase when we got them changed over.
Tracy Pearson PowerChurch Software
Ok crew ... after Richard Caruso found errors in my comptabs program i checked the download site and that version was uploaded nearly 10 years ago, so i uploaded the latest version ... if any cares to download and trial, cheers !
On Thu, 11 Feb 2016, at 11:36 PM, Tracy Pearson wrote:
Richard Caruso wrote on 2016-02-11:
Sure. It may have something to do with comparing data on mapped drives,
but
not sure. When I moved the two data folders and the exe to the C Drive,
it
worked great. I could snap a screen shot of the debugger at the state in which it errors, but I can't recall what upload site profox users use for image URLs. If anyone can let me know that would be great.
The error is "Invalid path or file name" on line CD "&LAUNCHDIR" in container1 click method.
IF !EMPTY(THISFORM.text1.VALUE) LAUNCHDIR=CURDIR() SDir=CHR(34)+ALLTRIM(THISFORM.TEXT1.VALUE)+CHR(34) CD &sDir MAXFILES=ADIR(FLSARR,'*.DBF') THISFORM.COMBO1.REQUERY --> CD "&LAUNCHDIR" ENDIF
LAUNCHDIR = "\COMPARES\COMPTABS" sdir = "S:\DATA\TI_DATA\185\EPCTDATA"
Richard,
Seeing the value of LaunchDir, one thing VFP does when it CD's into a directory ( SET DEFAULT TO also) is reads the folder above it to verify the folder you are heading to exists. I had a lot of trouble with some customers for a while.
If you were to CD to a folder below the Share "\COMPARES\COMPTABS\workingfolder" you would have better success. Some of our customers noticed a performance increase when we got them changed over.
Tracy Pearson PowerChurch Software
[excessive quoting removed by server]
Steve, can you email the URL for the current download and I'll give it a go. Thanks.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Weeks Sent: Friday, February 12, 2016 3:37 AM To: profox@leafe.com; profoxtech@leafe.com Subject: Re: DBF Compare
Ok crew ... after Richard Caruso found errors in my comptabs program i checked the download site and that version was uploaded nearly 10 years ago, so i uploaded the latest version ... if any cares to download and trial, cheers !
On Thu, 11 Feb 2016, at 11:36 PM, Tracy Pearson wrote:
Richard Caruso wrote on 2016-02-11:
Sure. It may have something to do with comparing data on mapped
drives,
but
not sure. When I moved the two data folders and the exe to the C
Drive,
it
worked great. I could snap a screen shot of the debugger at the state
in
which it errors, but I can't recall what upload site profox users use
for
image URLs. If anyone can let me know that would be great.
The error is "Invalid path or file name" on line CD "&LAUNCHDIR" in container1 click method.
IF !EMPTY(THISFORM.text1.VALUE) LAUNCHDIR=CURDIR() SDir=CHR(34)+ALLTRIM(THISFORM.TEXT1.VALUE)+CHR(34) CD &sDir MAXFILES=ADIR(FLSARR,'*.DBF') THISFORM.COMBO1.REQUERY --> CD "&LAUNCHDIR" ENDIF
LAUNCHDIR = "\COMPARES\COMPTABS" sdir = "S:\DATA\TI_DATA\185\EPCTDATA"
Richard,
Seeing the value of LaunchDir, one thing VFP does when it CD's into a directory ( SET DEFAULT TO also) is reads the folder above it to verify the folder you are heading to exists. I had a lot of trouble with some customers for a while.
If you were to CD to a folder below the Share "\COMPARES\COMPTABS\workingfolder" you would have better success. Some of our customers noticed a performance increase when we got them changed over.
Tracy Pearson PowerChurch Software
[excessive quoting removed by server]
Hi Richard ,
http://leafe.com/download/comptabs.7z
On the leafe.com download page it is at the top !
On Fri, 12 Feb 2016, at 02:15 PM, Richard Caruso wrote:
Steve, can you email the URL for the current download and I'll give it a go. Thanks.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Weeks Sent: Friday, February 12, 2016 3:37 AM To: profox@leafe.com; profoxtech@leafe.com Subject: Re: DBF Compare
Ok crew ... after Richard Caruso found errors in my comptabs program i checked the download site and that version was uploaded nearly 10 years ago, so i uploaded the latest version ... if any cares to download and trial, cheers !
On Thu, 11 Feb 2016, at 11:36 PM, Tracy Pearson wrote:
Richard Caruso wrote on 2016-02-11:
Sure. It may have something to do with comparing data on mapped
drives,
but
not sure. When I moved the two data folders and the exe to the C
Drive,
it
worked great. I could snap a screen shot of the debugger at the state
in
which it errors, but I can't recall what upload site profox users use
for
image URLs. If anyone can let me know that would be great.
The error is "Invalid path or file name" on line CD "&LAUNCHDIR" in container1 click method.
IF !EMPTY(THISFORM.text1.VALUE) LAUNCHDIR=CURDIR() SDir=CHR(34)+ALLTRIM(THISFORM.TEXT1.VALUE)+CHR(34) CD &sDir MAXFILES=ADIR(FLSARR,'*.DBF') THISFORM.COMBO1.REQUERY --> CD "&LAUNCHDIR" ENDIF
LAUNCHDIR = "\COMPARES\COMPTABS" sdir = "S:\DATA\TI_DATA\185\EPCTDATA"
Richard,
Seeing the value of LaunchDir, one thing VFP does when it CD's into a directory ( SET DEFAULT TO also) is reads the folder above it to verify the folder you are heading to exists. I had a lot of trouble with some customers for a while.
If you were to CD to a folder below the Share "\COMPARES\COMPTABS\workingfolder" you would have better success. Some of our customers noticed a performance increase when we got them changed over.
Tracy Pearson PowerChurch Software
[excessive quoting removed by server]
Hi Stephen, Thanks for uploading current version. This will be a fantastic tool for my toolbox. I gave it a go and here's my 1st run results below. Note the last VFP Error, which could be attempting to change folders back to pcCurrentDirectory, but failed. When I clicked on "Print the contents of this list", I got an error "File 's:\data\ti_data\185\epctdata\printcomp.dbf' does not exist.
User selected Dry Run, no changes will be made 010 - ARCEPCT.DBF Removing field ARCEPCTID 010 - ARCEPCT.DBF Removing field MERGED 008 - ARCMBRSMRY.DBF Adding field JURNYMNCNT 008 - ARCMBRSMRY.DBF Adding field GOLDCRDCNT 008 - ARCMBRSMRY.DBF Adding field PCT_COUNT 008 - ARCMBRSMRY.DBF Adding field RETIREE_50 010 - ARCMBRSMRY.DBF Removing field REGULARCNT 010 - ARCMBRSMRY.DBF Removing field PREVPCTKNT 010 - ARCMBRSMRY.DBF Removing field PREVPICKUP 016 - Adding index PCTSUMRYID on PCTSUMRYID 000 - Copying file S:\DATA\TI_DATA\185\EPCTDATA\DBFLIST.DBF VFP Error : - 1 File 's:\data\ti_data\147\epctdata\dbflist.dbf' does not exist. 020 - PCTPREFS.DBF Changing field LTR_TITLE 000 - Copying file S:\DATA\TI_DATA\185\EPCTDATA\PCTRATES - COPY.DBF VFP Error : - 1 File 's:\data\ti_data\147\epctdata\pctrates - copy.dbf' does not exist. 000 - Copying file S:\DATA\TI_DATA\185\EPCTDATA\TAGLIST.DBF VFP Error : - 1 File 's:\data\ti_data\147\epctdata\taglist.dbf' does not exist. 000 - Copying file S:\DATA\TI_DATA\185\EPCTDATA\TAGLOG.DBF VFP Error : - 1 File 's:\data\ti_data\147\epctdata\taglog.dbf' does not exist. VFP Error : - 202 Invalid path or file name.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Weeks Sent: Friday, February 12, 2016 9:59 AM To: profox@leafe.com; profoxtech@leafe.com Subject: Re: DBF Compare
Hi Richard ,
http://leafe.com/download/comptabs.7z
On the leafe.com download page it is at the top !
On Fri, 12 Feb 2016, at 02:15 PM, Richard Caruso wrote:
Steve, can you email the URL for the current download and I'll give it a go. Thanks.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Weeks Sent: Friday, February 12, 2016 3:37 AM To: profox@leafe.com; profoxtech@leafe.com Subject: Re: DBF Compare
Ok crew ... after Richard Caruso found errors in my comptabs program i checked the download site and that version was uploaded nearly 10 years ago, so i uploaded the latest version ... if any cares to download and trial, cheers !
On Thu, 11 Feb 2016, at 11:36 PM, Tracy Pearson wrote:
Richard Caruso wrote on 2016-02-11:
Sure. It may have something to do with comparing data on mapped
drives,
but
not sure. When I moved the two data folders and the exe to the C
Drive,
it
worked great. I could snap a screen shot of the debugger at the
state
in
which it errors, but I can't recall what upload site profox users use
for
image URLs. If anyone can let me know that would be great.
The error is "Invalid path or file name" on line CD "&LAUNCHDIR" in container1 click method.
IF !EMPTY(THISFORM.text1.VALUE) LAUNCHDIR=CURDIR() SDir=CHR(34)+ALLTRIM(THISFORM.TEXT1.VALUE)+CHR(34) CD &sDir MAXFILES=ADIR(FLSARR,'*.DBF') THISFORM.COMBO1.REQUERY --> CD "&LAUNCHDIR" ENDIF
LAUNCHDIR = "\COMPARES\COMPTABS" sdir = "S:\DATA\TI_DATA\185\EPCTDATA"
Richard,
Seeing the value of LaunchDir, one thing VFP does when it CD's into a directory ( SET DEFAULT TO also) is reads the folder above it to verify the folder you are heading to exists. I had a lot of trouble with some customers for a while.
If you were to CD to a folder below the Share "\COMPARES\COMPTABS\workingfolder" you would have better success. Some of our customers noticed a performance increase when we got them changed over.
Tracy Pearson PowerChurch Software
[excessive quoting removed by server]
Stephen, the code is in the label3 click method
--> use printcomp exclusive delete all pack append blank replace printcomp with thisform.edit1.value report form printcomp to printer prompt use
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Weeks Sent: Friday, February 12, 2016 9:59 AM To: profox@leafe.com; profoxtech@leafe.com Subject: Re: DBF Compare
Hi Richard ,
http://leafe.com/download/comptabs.7z
On the leafe.com download page it is at the top !
On Fri, 12 Feb 2016, at 02:15 PM, Richard Caruso wrote:
Steve, can you email the URL for the current download and I'll give it a go. Thanks.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Weeks Sent: Friday, February 12, 2016 3:37 AM To: profox@leafe.com; profoxtech@leafe.com Subject: Re: DBF Compare
Ok crew ... after Richard Caruso found errors in my comptabs program i checked the download site and that version was uploaded nearly 10 years ago, so i uploaded the latest version ... if any cares to download and trial, cheers !
On Thu, 11 Feb 2016, at 11:36 PM, Tracy Pearson wrote:
Richard Caruso wrote on 2016-02-11:
Sure. It may have something to do with comparing data on mapped
drives,
but
not sure. When I moved the two data folders and the exe to the C
Drive,
it
worked great. I could snap a screen shot of the debugger at the
state
in
which it errors, but I can't recall what upload site profox users use
for
image URLs. If anyone can let me know that would be great.
The error is "Invalid path or file name" on line CD "&LAUNCHDIR" in container1 click method.
IF !EMPTY(THISFORM.text1.VALUE) LAUNCHDIR=CURDIR() SDir=CHR(34)+ALLTRIM(THISFORM.TEXT1.VALUE)+CHR(34) CD &sDir MAXFILES=ADIR(FLSARR,'*.DBF') THISFORM.COMBO1.REQUERY --> CD "&LAUNCHDIR" ENDIF
LAUNCHDIR = "\COMPARES\COMPTABS" sdir = "S:\DATA\TI_DATA\185\EPCTDATA"
Richard,
Seeing the value of LaunchDir, one thing VFP does when it CD's into a directory ( SET DEFAULT TO also) is reads the folder above it to verify the folder you are heading to exists. I had a lot of trouble with some customers for a while.
If you were to CD to a folder below the Share "\COMPARES\COMPTABS\workingfolder" you would have better success. Some of our customers noticed a performance increase when we got them changed over.
Tracy Pearson PowerChurch Software
[excessive quoting removed by server]
On 2016-02-12 11:07, Richard Caruso wrote:
Stephen, the code is in the label3 click method
--> use printcomp exclusive delete all pack append blank replace printcomp with thisform.edit1.value report form printcomp to printer prompt use
May I ask why you did DELETE ALL and PACK rather than just using ZAP?
On Tue, 16 Feb 2016, at 11:20 AM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
May I ask why you did DELETE ALL and PACK rather than just using ZAP?
Zap doesn't fire any delete triggers that there might be in the database, that's one difference.
Richard, Not a solution but a quick point. Instead of using CD "&LAUNCHDIR" use cd (LAUNCHDIR) as it is quicker and also allows for spaces or delimiter characters in the path name.
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Richard Caruso Sent: 11 February 2016 21:00 To: 'ProFox Email List' profox@leafe.com Subject: RE: DBF Compare
Sure. It may have something to do with comparing data on mapped drives, but not sure. When I moved the two data folders and the exe to the C Drive, it worked great. I could snap a screen shot of the debugger at the state in which it errors, but I can't recall what upload site profox users use for image URLs. If anyone can let me know that would be great.
The error is "Invalid path or file name" on line CD "&LAUNCHDIR" in container1 click method.
IF !EMPTY(THISFORM.text1.VALUE) LAUNCHDIR=CURDIR() SDir=CHR(34)+ALLTRIM(THISFORM.TEXT1.VALUE)+CHR(34) CD &sDir MAXFILES=ADIR(FLSARR,'*.DBF') THISFORM.COMBO1.REQUERY --> CD "&LAUNCHDIR" ENDIF
LAUNCHDIR = "\COMPARES\COMPTABS" sdir = "S:\DATA\TI_DATA\185\EPCTDATA"
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Weeks Sent: Wednesday, February 10, 2016 4:09 PM To: profox@leafe.com; profoxtech@leafe.com Subject: Re: DBF Compare
Hi Richard, Care to share the tweaks and I can build them into teh original and upload again, I use this facility regularly to make comparisons and table alterations.
On Wed, 10 Feb 2016, at 05:40 PM, Richard Caruso wrote:
Thanks Alan, I was able to get CompTabs to work by Stephen Weeks after a few tweaks.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, February 10, 2016 11:39 AM To: profoxtech@leafe.com Subject: Re: DBF Compare
There are a couple in the Leafe.com downloads section.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
If you use Beyond Compare, there is a fantastic add-on by Frank Perez called VFP2Text.
http://pfsolutions-mi.com/Product/VFP2Text
For tables, it compares the column structures, indexes, code pages, triggers (all in the beginning of the compare). Then it compares records and data values in the columns.
Also works on all the other binary source files like forms, class libraries, reports, labels, menus, projects, and database containers. I use this add-on numerous times a week.
It should be a commercial tool, but Frank is generous and makes it available for free. Yes, you have to purchase Beyond Compare, but it is a steal for $50.
Rick White Light Computing, Inc.
www.whitelightcomputing.com www.swfox.net www.rickschummer.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Richard Caruso Sent: Wednesday, February 10, 2016 11:37 To: profoxtech@leafe.com Subject: DBF Compare
I was wondering if anybody new of a Table Comparison utility. I wrote a Fox2x utility a while back that compares two folders and generates reports on structure & index differences (i.e. Filename, Field Name, Field Type, Field Width, Error, where Error could be Field not found in Source or Field Width not equal, etc.). It doesn't work for VFP Tables as of yet and don't have time to debug it as I'm working on a deadline.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
On Wed, Feb 10, 2016 at 3:22 PM, Rick Schummer profox@whitelightcomputing.com wrote:
If you use Beyond Compare, there is a fantastic add-on by Frank Perez called VFP2Text.
And if you don't use Beyond Compare, you should! This utility has paid for itself over and over, when client's files have gotten mangled or you need to 'diff' text files.
I liked it so much, I bought a copy for everyone in the company!
Hey Rick, why didn't you mention FoxBin2Prg for this task? You know well this tool, even you have coded part of DBF data exporting!
Warm regards :D
Este correo electrónico se ha enviado desde un equipo libre de virus y protegido por Avast. www.avast.com https://www.avast.com/sig-email <#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
2016-02-10 21:22 GMT+01:00 Rick Schummer profox@whitelightcomputing.com:
If you use Beyond Compare, there is a fantastic add-on by Frank Perez called VFP2Text.
http://pfsolutions-mi.com/Product/VFP2Text
For tables, it compares the column structures, indexes, code pages, triggers (all in the beginning of the compare). Then it compares records and data values in the columns.
Also works on all the other binary source files like forms, class libraries, reports, labels, menus, projects, and database containers. I use this add-on numerous times a week.
It should be a commercial tool, but Frank is generous and makes it available for free. Yes, you have to purchase Beyond Compare, but it is a steal for $50.
Rick White Light Computing, Inc.
www.whitelightcomputing.com www.swfox.net www.rickschummer.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Richard Caruso Sent: Wednesday, February 10, 2016 11:37 To: profoxtech@leafe.com Subject: DBF Compare
I was wondering if anybody new of a Table Comparison utility. I wrote a Fox2x utility a while back that compares two folders and generates reports on structure & index differences (i.e. Filename, Field Name, Field Type, Field Width, Error, where Error could be Field not found in Source or Field Width not equal, etc.). It doesn't work for VFP Tables as of yet and don't have time to debug it as I'm working on a deadline.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Big mistake Rick! Sorry, was Doug Hennig who coded it. But is nice to read you anyway :D
Fernando.-
2016-02-10 22:24 GMT+01:00 Fernando D. Bozzo fdbozzo@gmail.com:
Hey Rick, why didn't you mention FoxBin2Prg for this task? You know well this tool, even you have coded part of DBF data exporting!
Warm regards :D
Este correo electrónico se ha enviado desde un equipo libre de virus y protegido por Avast. www.avast.com https://www.avast.com/sig-email <#-1855792113_DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
2016-02-10 21:22 GMT+01:00 Rick Schummer profox@whitelightcomputing.com:
If you use Beyond Compare, there is a fantastic add-on by Frank Perez called VFP2Text.
http://pfsolutions-mi.com/Product/VFP2Text
For tables, it compares the column structures, indexes, code pages, triggers (all in the beginning of the compare). Then it compares records and data values in the columns.
Also works on all the other binary source files like forms, class libraries, reports, labels, menus, projects, and database containers. I use this add-on numerous times a week.
It should be a commercial tool, but Frank is generous and makes it available for free. Yes, you have to purchase Beyond Compare, but it is a steal for $50.
Rick White Light Computing, Inc.
www.whitelightcomputing.com www.swfox.net www.rickschummer.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Richard Caruso Sent: Wednesday, February 10, 2016 11:37 To: profoxtech@leafe.com Subject: DBF Compare
I was wondering if anybody new of a Table Comparison utility. I wrote a Fox2x utility a while back that compares two folders and generates reports on structure & index differences (i.e. Filename, Field Name, Field Type, Field Width, Error, where Error could be Field not found in Source or Field Width not equal, etc.). It doesn't work for VFP Tables as of yet and don't have time to debug it as I'm working on a deadline.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Hi Fernando,
It is nice to be mixed up with Doug. I take it as a high compliment. FoxBin2Prg is another fine tool for this I guess, but I use Beyond Compare to do the file and folder comparisons and it has VFP2Text already built in now for years. Just part of the automatic processes I use to compare files whether VFP source or something else. No fuss, no muss.
Like Ted, every developer in our company has a license and we all love and rely on VFP2Text, and the great thing: if we want an enhancement, we ask our team mate Frank if he will make it for us. <g>
Rick White Light Computing, Inc.
www.whitelightcomputing.com www.swfox.net www.rickschummer.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Fernando D. Bozzo Sent: Wednesday, February 10, 2016 04:28 To: profoxtech@leafe.com Subject: Re: DBF Compare
Big mistake Rick! Sorry, was Doug Hennig who coded it. But is nice to read you anyway :D
Fernando.-
2016-02-10 22:24 GMT+01:00 Fernando D. Bozzo fdbozzo@gmail.com:
Hey Rick, why didn't you mention FoxBin2Prg for this task? You know well this tool, even you have coded part of DBF data exporting!
Warm regards :D
Este correo electrónico se ha enviado desde un equipo libre de virus y protegido por Avast. www.avast.com https://www.avast.com/sig-email <#-1855792113_DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
2016-02-10 21:22 GMT+01:00 Rick Schummer profox@whitelightcomputing.com:
If you use Beyond Compare, there is a fantastic add-on by Frank Perez called VFP2Text.
http://pfsolutions-mi.com/Product/VFP2Text
For tables, it compares the column structures, indexes, code pages, triggers (all in the beginning of the compare). Then it compares records and data values in the columns.
Also works on all the other binary source files like forms, class libraries, reports, labels, menus, projects, and database containers. I use this add-on numerous times a week.
It should be a commercial tool, but Frank is generous and makes it available for free. Yes, you have to purchase Beyond Compare, but it is a steal for $50.
Rick White Light Computing, Inc.
www.whitelightcomputing.com www.swfox.net www.rickschummer.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Richard Caruso Sent: Wednesday, February 10, 2016 11:37 To: profoxtech@leafe.com Subject: DBF Compare
I was wondering if anybody new of a Table Comparison utility. I wrote a Fox2x utility a while back that compares two folders and generates reports on structure & index differences (i.e. Filename, Field Name, Field Type, Field Width, Error, where Error could be Field not found in Source or Field Width not equal, etc.). It doesn't work for VFP Tables as of yet and don't have time to debug it as I'm working on a deadline.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
I've been a fan of Beyond Compare ever since stumbling across it a few years ago. VFP2Text is a fantastic add-on. Thanks for sharing.
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Rick Schummer Sent: Wednesday, February 10, 2016 3:22 PM To: profox@leafe.com Subject: RE: DBF Compare
If you use Beyond Compare, there is a fantastic add-on by Frank Perez called VFP2Text.
http://pfsolutions-mi.com/Product/VFP2Text
For tables, it compares the column structures, indexes, code pages, triggers (all in the beginning of the compare). Then it compares records and data values in the columns.
Also works on all the other binary source files like forms, class libraries, reports, labels, menus, projects, and database containers. I use this add-on numerous times a week.
It should be a commercial tool, but Frank is generous and makes it available for free. Yes, you have to purchase Beyond Compare, but it is a steal for $50.
Rick White Light Computing, Inc.
www.whitelightcomputing.com www.swfox.net www.rickschummer.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Richard Caruso Sent: Wednesday, February 10, 2016 11:37 To: profoxtech@leafe.com Subject: DBF Compare
I was wondering if anybody new of a Table Comparison utility. I wrote a Fox2x utility a while back that compares two folders and generates reports on structure & index differences (i.e. Filename, Field Name, Field Type, Field Width, Error, where Error could be Field not found in Source or Field Width not equal, etc.). It doesn't work for VFP Tables as of yet and don't have time to debug it as I'm working on a deadline.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
Hi Richard:
If you want to Diff DBF structures as this example:
https://drive.google.com/open?id=0B_qHXcWqGDY-cGFzQVAybzQyV1E
then FoxBin2Prg may be useful for you.
Best Regards.-
Este correo electrónico se ha enviado desde un equipo libre de virus y protegido por Avast. www.avast.com https://www.avast.com/sig-email <#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
2016-02-10 17:37 GMT+01:00 Richard Caruso rcaruso@acutedesigns.com:
I was wondering if anybody new of a Table Comparison utility. I wrote a Fox2x utility a while back that compares two folders and generates reports on structure & index differences (i.e. Filename, Field Name, Field Type, Field Width, Error, where Error could be Field not found in Source or Field Width not equal, etc.). It doesn't work for VFP Tables as of yet and don't have time to debug it as I'm working on a deadline.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
-
Alan Bourke -
Dave Crozier -
Fernando D. Bozzo -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Richard Caruso -
Rick Schummer -
Stephen Weeks -
Ted Roche -
Tracy Pearson