PowerBuilder Interview Question and Answers

66. When would you use SetTrans()?
  We use SetTrans() 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.
 
Your Name Your Email-ID
Your Answer
67. Define ‘Retrieve Only as Needed’?
  PowerBuilder displays the first row on the screen when its complete retrieveing. When we scroll downward additional rows are retrieved.
 
Your Name Your Email-ID
Your Answer
68. How PowerBuilder search for a function?
  Bottom - to -Top.
 
Your Name Your Email-ID
Your Answer
69. How PowerBuilder search for a function?
  Top - to - Bottom.
 
Your Name Your Email-ID
Your Answer
70. Will it ignore extra retrieve arguments to the Retrieve() function?
  YES, it will ignore extra arguments.
 
Your Name Your Email-ID
Your Answer
71. Explain AcceptText() function.
  AcceptText() function applies the content of the edit control to the PrimaryBuffer after validating the data. We can also specify to the Update() via argument of call AcceptText() internally before applying the changes to the database.
AcceptText() 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.
 
Your Name Your Email-ID
Your Answer
72. Explain DBERROR() & ERROR() event.
  DBERROR() event is fired when a database related error occurs.
ERROR() event at the DataWindow control level is triggered, when a wrong expression is encountered in the object notaiton.
 
Your Name Your Email-ID
Your Answer
73. How to load a text file in a DataWindow?
  We can use ImportFile() function.
 
Your Name Your Email-ID
Your Answer
74. What STATUS occurs When a row is copied from another DataWindow?
  NewModified!
 
Your Name Your Email-ID
Your Answer
75. What are the buffers will maintain a DataWindow if set to ReadOnly?
  All the four buffers. Primary!, Original!, Delete!, Filter!.
 
Your Name Your Email-ID
Your Answer