Dynamic SQL Tracing in Application

While debugging we might want to know the SQL generated for the particular event. So we increase the log level to 5 OR we enable sql spooling.
In both cases, it is difficult to find the sql's generated only for the particular event. The following configuration will help you out to turn on/off sql spooling and there by analysing the sql generated only for the events.

Set/Get Profile Attributes at runtime

To set Profile attributes we normally write script code in an object and then compile it. But to set/get profile attibutes dynamically i.e, while the application is running we make use javascript prompt at IE addressbar.

To set profile attributes, type the following line in IE address bar and press enter key.
javascript:alert(theApplication().SetProfileAttr("ProfileAttrTest","SiebelForum"))


To get profile attribute which is set in above step, type the following line in IE address bar and press enter key.
javascript:alert(theApplication().GetProfileAttr("ProfileAttrTest"))


This will display the popup message with the Profile attribute set previously.

Message Popup in Siebel e-Script

While debugging in siebel escript some times we may want to know value for a variable. Instead of using script debugger we can just write a code to popup the variable. If we use TheApplication().RaiseErrorText() in e-script it will stop the execution of code, but if we want to know the values for the variables and continue with code execution then the following code will help.

var WshShell = COMCreateObject("WScript.Shell");

WshShell.Popup("In Applet Load Method",0,"Siebel");

WshShell = null;