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]