RE: [sqr-users] Email from SQR

["Fisher, Sandy K" <skfisher@ou.edu>]

Thanks for your help with the email.  I will try some of these.

-----Original Message-----
From: Rick_Creel@aoncons.com [mailto:Rick_Creel@aoncons.com]
Sent: Thursday, January 09, 2003 2:15 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Email from SQR



The info you've given is very minimal.  Will this SQR be running on client
or server?  What environment?
We have several SQRs that send email.  The are run on our UNIX server and
issue a "call system" command to invoke the sending of the email.  What I
found out is that the SQR that creates the report can NOT be the SQR that
issues the "call system" command.  The have a 2-step approach:
1) the report generation SQR will make an entry in a email parameter table
and among other things, it will store the path of where the report is
located and the actual name of the report.
2) immediately after the report SQR has completed, the email SQR is
initiated.  It will get the parameters that were stored in the table and
then build a command string that is appropriate for the email program that
runs on our UNIX box.  The last thing the email SQR does is:   Call System
Using  $command_string  #status

Hope this helps.




 

                      "Fisher, Sandy K"

                      <skfisher@ou.edu>        To:
"'sqr-users@sqrug.org'" <sqr-users@sqrug.org>      
                      Sent by:                 cc:

                      sqr-users-admin@s        Subject:  [sqr-users] Email
from SQR                         
                      qrug.org

 

 

                      01/09/2003 02:52

                      PM

                      Please respond to

                      sqr-users

 

 





Is there a way to generate an email from an sqr program that would send a
report?  Thanks.

_______________________________________________
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

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