[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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