Hi,
 
I am trying to print a pdf report to a subdirectory and am getting a file in use error even though the file does not exist.  Sharing has been set on all subdirectories.
 
The commands that I am using are:
 
set var vyears= ''05'
 
SET VAR vyears = '(''' + .vyears + ''')'
 
set var filert ='\monthend\2005\ncardmonth92005.pdf'
 
set var test=('PRINT ncardmonth  WHERE issue_year IN '+ .vyears  + ' AND cards_ltd IS NOT NULL AND active IS NOT NULL ORDER BY issue_year, issue_month OPTION pdf|filename  '+.filert+ '|open OFF')
 
&test
 
 
With the sho var command, the test variable looks like this:
 
 PRINT ncardmonth  WHERE issue_year IN ('05') AND  cards_ltd IS NOT NULL AND active IS NOT NULL ORDER BY  issue_year, issue_month  OPTION pdf|filename \monthend\2005\ncardmonth92005.pdf|open OFF
 
 
If I remove the subdirectories from the filename variable, the report will print.
 
Is there something that I am missing?
 

Ted Wolfley
Database/Internet Programmer
The Ogden Group of Rochester

5637  West Henrietta Road

West Henrietta, NY 14586
phone: (585) 321 1060 x23
fax: (585) 321 0043

[EMAIL PROTECTED]

www.ogdengroup.com

 

Reply via email to