Place this code and the SQL will be printed on the html page as software
message.
//[[SPIDER_EVENT<this_onBeforeExecuteEvent>
public int this_onBeforeExecuteEvent(CSpDataObjectEvent event)
{
CSpDBSQLRequest sqlRequest =
(CSpDBSQLRequest)event.getDBRequest();
String strSQL = sqlRequest.getSQLProgram();
CSpHtml.write("SQL is : " + strSQL );
}
//[[SPIDER_EVENT<this_onBeforeExecuteEvent>
Shankar.
> ----------
> From: Shamdasani Nimmi-ANS004[SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 18, 1999 9:40 PM
> To: 'NetDynamics'
> Subject: [ND] Log file
>
> I want to read from the log file the complete SQL being executed. Since
> SQL
> is quite long I can't see it completely from the log viewer. Is there
> another way to do that?
>
> -Nimmi
>
>
> _________________________________________________________________________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
