Bill Just a thought but try setting your radio button variable to null after printing the report. Maybe the calling eep in the form is causing the printing over and over
Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Monday, February 16, 2009 12:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problem printing to PDF file Dennis This report is called by clicking a radio button. Radio Buttons are: Screen Printer PDF Excel Word Doc It is when I click the PDF or Excel or Word Doc button that the report keeps printing. There are no While loops in the code for any button. If you like I can post the entire code. Thanks, Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Monday, February 16, 2009 11:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problem printing to PDF file Is this code called directly by clicking a button, or is it called by some intermediate code? It sounds like you have an endless loop somewhere that keeps calling your print routine. This could be and actual code loop, or it could be one routine that call another that calls the first in and endless race. One way to isolate it is to put a pause at the top of your routine that you have to respond to. This will tell you if the rountine is being called several times. At least it will help indicate if the problem is in the routine or elsewhere. Dennis -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Monday, February 16, 2009 10:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problem printing to PDF file Dennis, Turn off/turn on did not resolve the problem. I can delete the PDF file via Windows Explorer with no problem. Thanks, Bill Eyring -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Monday, February 16, 2009 11:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problem printing to PDF file Bill, Have you tried powering down and restarting the computer? When things just don't make sense that is my first debugging option. That way I do not spend endless hours debugging a problem that is really caused by hardware/OS hiccups. Also, check the target pdf file when the computer comes back up. See if you can delete it. Dennis McGrath -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Monday, February 16, 2009 10:03 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problem printing to PDF file Dan, I've already done that. The trace and debug shows no problems and executes as expected. I suspect a different problem. Thanks, Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Monday, February 16, 2009 10:45 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problem printing to PDF file You will need to trace to find your error. Add this to your eep Set debug on Set trace on This will allow you to go line by line tracing out the error. Dan Goldberg -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Monday, February 16, 2009 7:38 AM To: RBASE-L Mailing List 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
