dbcopy
Richard Kreiss
rkreiss at verizon.net
Mon May 24 07:45:44 PDT 2010
I have a routine which has been running for over 10 years without a hitch.
However since April this routine is having a problem.
Windows server 2005, filepro 5.0, windows xp pro
The problem started when my client was purchased by a new company and moved
their server and computer to their offices. All of the drive mappings have
stayed the same.
Startup file:
@echo off
rem This File created by install shield
set PFDSK=W
set PFDATA=W:
set PFPROG=W:
set PFDIR=
set PFMENU=W:\FP\MENUS
set PFGLOB=
set PFCONFIG=
set PFTMP=W:\temp
set PATH=%PFPROG%\fp;%path%
%PFPROG%\p.exe ls_menu
Menu option:
@echo off
echo **********************************************
ECHO ****** Beginning EDI Order Conversion ******
echo ****** ******
echo ****** Press CTRL C To Cancel ******
ECHO **********************************************
PAUSE
@dprodir ls_850x -l
@dprodir ls_850 -l
@dprodir sr_sndet -l
@dprodir ls_850x -ka
@dbcopy 850 ls_850x
pause
@dxmaint ls_850x -ra -h "One Moment Please - Updating Indexes" -e
@rreport ls_850x -f dup_orde -a -h "Checking if Duplicate Order(s)" -u
@rreport ls_850x -f update -a -h "Updating EDI details" -U
@rreport ls_850x -f summary -a -h "Printing Summary Receipt Report" -u
@rreport ls_850x -f post_850 -a -h "Post To EDI File" -U
@dxmaint ls_850x -o1 -rf 2:3:4:11 -a -h "Updating Index A" -e
@rreport ls_850 -f post_qual -a -v sel_today -ik -u -h "Post To ASN"
The problem is with the dbcopy. The file 850.dbf is located in w:\. This
file contains edi data. Currently when this menu option is selected the
records being copied from 850.dbf are from an order received in April
although the current 850.dbf file exists on w:\.
If I run dbcopy manually from the filepro utility menu, the correct file is
copied.
I have done a search of the W:\ drive for another copy of 850.dbf. I have
searched the local c: drive for a copy of 850.dbf and have found none.
Anyone have a suggestion as to:
1. why this command should fail now to find w:\850.dbf
2. Suggest where else to look for the older version of 850.dbf with the old
edit data
More information about the Filepro-list
mailing list