[sqr-users] RE: FTP from SQR.

["White, Denise" <DEWhite@vicr.com>]

Hi Sudeep,

After you finish writing the report and before you FTP it, issue the new-report 
command.  This will close your current report, causing it to create the output 
file.  Since you are not going to write anything to the new report, you do not 
need to specify a name in the new-report command.  (Disclaimer: this always 
worked in earlier versions with .lis file output, so I am assuming it will 
continue to work the same way with .pdf output; someone please correct me if 
I'm wrong)

HTH,

Denise M. White
Sr. Software Engineer
HR/Payroll Systems
Vicor Corporation
------------------------------

Message: 2
Date: Mon, 18 Oct 2004 16:25:34 +0530
From: "Sudeep Vaidya" <sudeep.vaidya@patni.com>
Subject: [sqr-users] FTP from SQR.
To: <sqr-users@sqrug.org>
Message-ID: <001b01c4b500$febc7e90$b585a8c0@patni.com>
Content-Type: text/plain;       charset="iso-8859-1"

Hi All,

We are creating a report (PDF ) file from a SQR. The PDF is to be FTPd to a
remote server.

1.My Procedure Print-to-file is Printing the data to the PDF file using the
Print Statements.
2. After Print-to-file is complete, I'm calling my procedure Do-FTP-File
which would FTP the file using the Call system commands
in Unix.

Even When the procedure Print-to-File is complete, probably the control of
the PDF is not released till the SQR is executing.
Hence my procedure Do-FTP-File  fails as it cannot find the file . Probably
the file is not even written to the disk at that time.
And even if it is written, perhaps the SQR is holding the Control through
the Operating System.

If I were creating a DAT file using Write Statements, I could have
explicitly closed the file using the Close Statement.

Question .How can I force the SQR to release the Control of the PDF after
the Print-to-file procedure is complete, so that the file is closed and can
be picked for FTP by the procedure Do-FTP-File .

Best Regards,

Sudeep

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users