a2zinterviews

86.	Explain CloseQuery event?
	PowerBuilder triggers CloseQuery event before it triggers Close event. If CloseQuery event’s script not executed successfully close event will nerver trigger.
	Discuss Your Name Your Email-ID Your Answer

87.	Which function is used to change a validation rule in DataWindow at runtime?
	SetValidate().
	Discuss Your Name Your Email-ID Your Answer

88.	Which comman/function will blank out a DataWindow?
	Reset().
	Discuss Your Name Your Email-ID Your Answer

89.	Explain Transaction Objects?
	Transaction object contains the necessery informaiton needed to connect to a database. Like user id , password.. SETTRANSOBJECT() SetTransObject tells the DataWindow to use specified transaciton object. SETTRANS() The DataWindow control connects and disconnects after each Retrieve or Update function while using SetTrans When we use SetTrans we can’t update multiple DataWindow object.
	Discuss Your Name Your Email-ID Your Answer

90.	Explain SQLSA?
	Dynamic Staging Area is internally used by PowerBuilder and is the connection between execution of a statement and Transaction object. SQLSA contains no.of parameters and SQL statements.
	Discuss Your Name Your Email-ID Your Answer

91.	Explain SQLDA?
	Dynamic Description Area stores information about input and output parameters. The two principle of dynamic SQL are PREPARE and EXECUTE.
	Discuss Your Name Your Email-ID Your Answer

92.	Explain types of Windows in PB?
	MAIN A standlone overlaped window that can be independed of all other windows. Used for single window application. CHILD A window that is dependent on a main window and can only exist within the main(PARENT) window. If minimize the main window as well as the child window is minimizsed. A child window cannot beyond the parent window. MDI MDI window allows to open multiple window as sheet inside it. When a window inside the MDI window it minimize and maximized wheet icon is displayed at the bottom of the MDI window. MDIHELP MDIHELP window has additional feature of a status bar at the bottom of the MDIHELP window. This status bar used to display help text like run time. POPUP POPUP window depends on it parent window. POPUP window will behave like a main window. IT the parent window is minimized POPUP window will be hidden. RESPONSE RESPONSE window equalent of a window dialog box. When a response window is opened from another window the response window can’t minimize and maximize untill the user gives response to the window can»t get another window.
	Discuss Your Name Your Email-ID Your Answer