[sqr-users] Re: FTP from SQR.

[Rebecca.Barilleaux@anthem.com]

Sudeep,

You just need to issue the new-report command before you attempt to ftp the
file.  Using new-report will close the current pdf file, and will only
start writing to the new file only if you have any further print statements
after the new-report command.

Rebecca



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

http://www.patni.com
World-Wide Partnerships. World-Class Solutions.







CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, 
is for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.

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