CVRT File wont work after moving to a new computer?? 1

wlpsyp · Apr 3, 2003

howdy...

I just received my new high end computer, installed Visual Studio 6.0. Setup went well. Opened up VFP6 with no issues. On my old computer I opened up my CVRT files and copied them one at a time to notepad then transfered to my new computer. I then opened up VFP and started a new .prg by doing "modify command fracvrt" no problem. I copied the below code from notepad into the new fracvrt file, safed it all went well. I ten at teh command widow typed "do fracvrt" and I get errors now and do not know why, it still works fine on my old computer with this same file, no issues.

The erros I get are on line 2 USE R:\RTLPAS10\RFMSS35\DATA\REQUEST.DBF (SAYS FILE IS IN USE, It is not, this is a mapped drive to my server)

The 2nd error is this line SET TEXTMERGE TO (OutFile) (SAYS INVALID PATH OR FILE NAME)

I have done nothing to the code at all, just changed it to a different computer, As I stated it still runs fine on the old computer with no issues. I have three cvrt files and have tried all three on this new computer with the same results Why?

Any advice is GREATLY appriciated.

SET EXCLUSIVE OFF
USE R:\RTLPAS10\RFMSS35\DATA\REQUEST.DBF (SAYS FILE IS IN USE, It is not, this is a mapped drive to my server)

DO WHILE .T.
WAIT WINDOW NOWAIT 'Waiting... <Esc> to exit, any other key to update now.'
x=INKEY(300) &&... 300 seconds = 5 minutes.
IF x = 27 &&... Escape key pressed
EXIT
ENDIF
DO MakeHTML WITH DATE(), DATE() + 90, ;
"X:\Inetpub\

http://wwwroot\FRA90Day.HTML"

DO MakeHTML WITH DATE() + 91, DATE() + 180, ;
"X:\Inetpub\

http://wwwroot\FRA180Day.HTML"

DO MakeHTML WITH DATE() + 181, DATE() + 260, ;
"X:\Inetpub\

http://wwwroot\FRA260Day.HTML"

DO MakeHTML WITH DATE(), DATE() + 365, ;
"X:\Inetpub\

http://wwwroot\FRAInclusive.HTML"

ENDDO
CLOSE ALL

FUNCTION MakeHTML
PARAMETERS UseDate, EndDate, OutFile

SELECT USEDAY, ENDDAY, TRAINING, ;
UnitName, Tra_Area ;
FROM Request ;
WHERE BETWEEN(USEDAY,UseDate, EndDate );
ORDER BY USEDAY;
INTO CURSOR tmp

SELECT tmp
&&... Use 'OutFile' parameter instead of actual file name
SET TEXTMERGE TO (OutFile)
SET TEXTMERGE ON NOSHOW
\\<HTML><HEAD><TITLE>Requests by Date</TITLE></HEAD>
\<BODY>
\<TABLE BORDER=5 ALIGN=CENTER WIDTH=70%>
nCounter = 0
SCAN
IF (nCounter % 20)=0 &&... every 20 rows
\<TR>
\ <TH>Use Day
\ <TH>End Day
\ <TH>Training to be Conducted
\ <TH>Using Unit
\ <TH>Range/Training Area
\</TR>
ENDIF
nCounter = nCounter + 1

\<TR>
\ <TD><<Useday>>
\ <TD><<ENDDAY>>
\ <TD><<Training>>
\ <TD><<UnitName>>
\ <TD><<Tra_Area>>
\</TR>
ENDSCAN
SET TEXTMERGE TO
RETURN It's not a problem...It's just a Blood Pressure Monitor

wgcs · Apr 3, 2003

Is the X: drive also mapped properly on this computer?
Can you successfully:
MODI COMM "X:\Inetpub\

http://wwwroot\FRA90Day.HTML"

then make changes and save it?

How do you KNOW that the R:\RTLPAS10\RFMSS35\DATA\REQUEST.DBF file is not in use? Sometimes servers get a file "stuck" in-use, and you have to restart the server to free them (particularly with windows servers).

A program like NetWatch can tell you what client the server thinks has the file open.

wlpsyp · Apr 4, 2003

WGCS, Thanks for the insight. I do not know what it was or still is. I did nothing new today when I came in and it worked. I know the file was not in use as I checked it and even rebooted the server to be sure. X:\ drive was and is mapped correctly and all permissions were set properly. Maybe just a hick-up, dont know. But thanks for the advise and interest.

Bill It's not a problem...It's just a Blood Pressure Monitor

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

CVRT File wont work after moving to a new computer?? 1

wlpsyp

IS-IT--Management

wgcs

Programmer

wlpsyp

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor