Is there a way to log all of the SQL calls to a database to the vortex.log but not have them go to STDOUT on the script??? I am trying track down a list of calls during a certain period of time to see if any of them are searching columns that don't have indexes. And we have hundreds of scripts that I would have to audit if I did it by hand.
See <TRACESQL> and <sqlcp tracesql> in the Vortex manual: these will turn on logging of SQL statements. They will be printed to stdout as well, though in comments (if HTML mode) like other messages. You can write a <putmsg> function to turn this off if you wish (ie. suppress the 200-level trace message but print any other real error message).
