Dawn,
My code changes the date format prior to printing to the file as follows;
set date for mmddyy
set v vdate=(ctxt(.#date))
set v vdate text
set v vfile=('CliList_'+.vdate+'.XLS')
My file name is "CliList021609.pdf"
Thanks,
Bill
_____
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Monday, February 16, 2009 11:36 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Problem printing to PDF file
Bill
It's the "vdate" variable in your file name. You can't have slashes in your
file name.....
Dawn Hast
"Bill Eyring" <[email protected]>
Sent by: [email protected]
02/16/2009 11:14 AM
Please respond to
[email protected]
To
[email protected] (RBASE-L Mailing List)
cc
Subject
[RBASE-L] - Re: Problem printing to PDF file
Jan,
Good thought, but the filename as set in the code is;
set v vfile=('CliList_'+.vdate+'.XLS')
set v vfile=(srpl(.vfile,'xls','pdf',0))
print clilist order by cllast option pdf +
|filename .vfile +
|open on
So the filename would be "CliList021609.pdf"
Thanks,
Bill Eyring
_____
From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen
Sent: Monday, February 16, 2009 11:02 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Problem printing to PDF file
Bill,
I think you mention that this is the only one behaving this way.
If so, is it possible that the pdf generated has the phrase
'theend' anywhere in it?
Jan
-----Original Message-----
From: "Bill Eyring" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Mon, 16 Feb 2009 10:38:16 -0500
Subject: [RBASE-L] - Problem printing to PDF file
Hello All,
I've spent my Presidents Day weekend perplexed and dismayed by a problem I
have printing a simple report to a pdf file.
I have many instances in my program where I print to a pdf file without
problems.
For some reason this report decides it wants to print to a pdf file for as
many times as I let it.
I have checked my code a zillion (okay, many) times. I have checked all my
settings, they remain unchanged from the prior version.
I am using the latest Turbo V8 (8.0.20.30214).
Here is the code I use to produce the report;
--some code
set v vfile text=null
set date for mmddyy
set v vdate=(ctxt(.#date))
set v vdate text
set date for mm/dd/yyyy
--some code
set v vfile=('CliList_'+.vdate+'.XLS')
--some code
if vout='pdf' the
if vcaption='Client List - Alpha' the
set v vfile=(srpl(.vfile,'xls','pdf',0))
print clilist order by cllast option pdf +
|filename .vfile +
|open on
goto theend
endi
endi
--some code
label theend
set v vout=null
--some code
return
When I click to print the report to a pdf file, it executes the above code.
The report prints to the correct filename. When I close the pdf file the
code executes again and will keep re-printing rather then going to my label
THEEND.
If I click on my form Close button to stop the print I get this message
"File could not be created !"
"Possible cause:It could be in use by some other application."
"Solution:Re-try the failed operation after closing the other application or
specify another file name. OK."
This is code I have used over and over with no problems. Can anyone tell me
what the problem could be ?
I have autochked th db and it comes back clean, the settings in my startup
file are unchanged, I am loosing my hair ! Help !
Bill Eyring
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy, disclose
or use the contents in any way. Please also advise us by return e-mail that
you have received the message and then please destroy. Evergreen Packaging
is not responsible for any changes made to this message and / or any
attachments after sending by Evergreen Packaging. We use virus scanning
software but exclude all liability for viruses or anything similar in this
email or any attachment.
