[RBASE-L] - Re: Problem printing to PDF file

[Bill Eyring]

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: rbase-l@rbase.com [mailto:rbas...@rbase.com] 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" <beyr...@lampsoftware.com> 
To: rbase-l@rbase.com (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