RE: [sqr-users] FTP from SQR.

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

Hi Sudeep,
A new-report command should close the output file so you can print it.
Steve. 

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On
Behalf Of Sudeep Vaidya
Sent: Monday, 18 October 2004 8:56 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] FTP from SQR.

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.
_____________________________________________________________________

This e-mail message may contain proprietary, confidential or legally
privileged information for the sole use of the person or entity to whom this
message was originally addressed. Any review, e-transmission dissemination
or other use of or taking of any action in reliance upon this information by
persons or entities other than the intended recipient is prohibited. If you
have received this e-mail in error kindly delete  this e-mail from your
records. If it appears that this mail has been forwarded to you without
proper authority, please notify us immediately at netadmin@patni.com and
delete this mail. 
_____________________________________________________________________

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



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