---------- Original Message ----------- From: "peixinhosdalua" <[email protected]> > Is it possible to make a output of the variable this_query to view if > all newly formed variable is correct? Something like a send_to_log() > > send_to_log(this_query); > for execute statement :this_query into :a, :b, :c, ..., :z do > suspend; > end ------- End of Original Message -------
a) Create a logging table, and insert into that logging table where you currently have send_to_log(). (results won't be visible to other transactions until you commit, so for testing, you may want to execute this procedure manually in your database tool and then check the log table, all in the same transaction.) b) There are probably UDF's to help you write to a filesystem log file. I wrote my own for convenience, but you might check out http://rfunc.sourceforge.net/rfunc.htm which has some file-handling functions already written for you (they're pretty raw, you'll have to open the file handle, then write, then ...) -Philip
