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

Re: [sqr-users] Save As for Text Files




You could add the hours and minutes (and maybe even seconds) to the file
name, along with the date, just in case you need to run the SQR several
times in 1 day.  By adding the date & time to the filename you should
always get a unique name.  The file doesn't have to already exist in order
to open it for writing.

HTH

------------------------------------------
Ramzi Salameh
PeopleSoft Technical Analyst
Dave & Busters, Inc.
------------------------------------------



                                                                                
                                                        
                      "Prasanna Menta"                                          
                                                        
                      <pmenta@umuc.edu>        To:       sqr-users@sqrug.org    
                                                        
                      Sent by:                 cc:                              
                                                        
                      sqr-users-admin@s        Subject:  Re: [sqr-users] Save 
As for Text Files                                         
                      qrug.org                                                  
                                                        
                                                                                
                                                        
                                                                                
                                                        
                      01/07/03 09:24 AM                                         
                                                        
                      Please respond to                                         
                                                        
                      sqr-users                                                 
                                                        
                                                                                
                                                        
                                                                                
                                                        




If you are using Peoplesoft, you can use your process instance
concatenated with the date which might be a good solution. If not you
need to initialise a counter which needs to be stored at a back end
table and update the counter each time when a new process is run and use
this to get the file name
Hope this helps
Prasanna

James Lanter wrote:
>
> This one seems easy, but I'm at a lost.
>
> Basically, I need to create a new text file each time the SQR is run.
> The output has to be a fixed length text file and I use the date in the
> file name.  The problem is I can't open a text file that is not there
> and I don't want to overwrite a previous run's output.  Am I missing
> something simple here?
>
> Thanks!
>
> Jamie
>
> _______________________________________________
> 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