Re: SP URGENT HELP: SYSTEM .. to keep a log file

George C Parobek <george@icc-gcp.demon.co.uk> wrote in article <01bbdc4f$082fd460$7e8a989e@gcp-client>... > I am using SP for Client Server application. > In order to monitor and check the update procedures I need to log the > progress in a unix text file. e.g.: > > SYSTEM "echo "||text||" >> log_file"; > > This command takes too long top process, cca. 1sec !!!!!! > > Is there a better way of achieving the same goal. > > Please HELP > -- > george@icc-gcp.demon.co.uk > I have received two suggestions (many thanks for comunicating): 1. use a DB table as a log file: - problem with this solution is, that if database crashes or gets corrupted there is no trace of update history 2. use trace on function: - this works OK, but the log file gets overwritten each time the trace is started. I would have to have a separate log file for each updadte run and each function. I am looking for a similar function to that in 4GL errorlog(...) Many thanks for the efford and hope to hear more ideas.