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.
