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:[email protected]] On Behalf Of Stephen Weeks Sent: Friday, February 12, 2016 9:59 AM To: [email protected]; [email protected] 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:[email protected]] On Behalf Of Stephen Weeks > Sent: Friday, February 12, 2016 3:37 AM > To: [email protected]; [email protected] > 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
