LANGUAGES | POWER BUILDER | POWER BUILDER INTERVIEW QUESTION AND ANSWERS - 17

Power Builder Interview Question and Answers:

86.     Explain Close Query event?
      Power Builder triggers Close Query event before it triggers Close event. If Close Query event’s script not executed successfully close event will nerver trigger.

87.     Which function is used to change a validation rule in Data Window at run time?
      Set Validate().

88.     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.

89.     Explain HELT CLOSE keyword?
      When PB encounters HALT without the keyword CLOSE, it immediately terminates the application.
When PB encouters HALT with the keyword CLOSE, it immediately executed the script for the close event for the application and then terminates the applicaiton.

90.     Explain MDI?
      MDI stand for Multiple Document Interface. It is an application style that allows users to open multiple windows(called sheets) in a single window(called MDI Frame) and to move freely among these sheet.

MDI has two PB window styles:

    MDI Frame
    MDI Frame with MicroHelp

MDI Frame has three parts:

    Frame
    Client Area
    Sheets

91.     Which comman/function will blank out a Data Window?
      Reset().

92.     Explain Transaction Objects?
      Transaction object contains the necessery informaiton needed to connect to a database. Like user id , password..

SET TRANS OBJECT()
Set Trans Object tells the Data Window 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.

93.     Explain SQLSA?
      Dynamic Staging Area is internally used by Power Builder and is the connection between execution of a statement and Transaction object. SQLSA contains no.of parameters and SQL statements.

94.     Explain SQLDA?
      Dynamic Description Area stores information about input and output parameters. The two principle of dynamic SQL are PREPARE and EXECUTE.

95.     How to open a window with a parameter?
     
Opening window with a parameter
   
Stored in
Open With Param()
   
Message.String Param
Open Sheet With Param()
   
Message.Double Param
Open User Object With Param()
   
Message.Power Object Param
Close With Return()