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

Power Builder Interview Question and Answers:

66.     Explain DB ERROR() & ERROR() event.
      DB ERROR() event is fired when a database related error occurs.
ERROR() event at the Data Window control level is triggered, when a wrong expression is encountered in the object notaiton.

67.     How to load a text file in a Data Window?
      We can use Import File() function.

68.     What STATUS occurs When a row is copied from another Data Window?
      New Modified!

69.     What are the buffers will maintain a Data Window if set to Read Only?
      All the four buffers. Primary!, Original!, Delete!, Filter!.

70.     When would you use Set Trans()?
      We use Set Trans() when only a limited No. of connections to the DB is allowed or we are only retrieving data and do not need to hold DB locks on records the user is modifying.

71.     Define ‘Retrieve Only as Needed’?
      Power Builder displays the first row on the screen when its complete retrieveing. When we scroll downward additional rows are retrieved.

72.     How Power Builder search for a function?
      Bottom - to -Top.

73.     How Power Builder search for a function?
      Top - to - Bottom.

74.     Will it ignore extra retrieve arguments to the Retrieve() function?
      YES, it will ignore extra arguments.

75.     Explain Accept Text() function.
      Accept Text() function applies the content of the edit control to the Primary Buffer after validating the data. We can also specify to the Update() via argument of call Accept Text() internally before applying the changes to the database.
Accept Text() function should no be called from ItemChanged event. This is because AcceptText() function triggers the ItemChanged event.

Return value is .
Return 1 if succeeds and -1 if its fails.