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

Power Builder Interview Question and Answers:

26.     What is the difference between SQLCA.SQL Code and the value returned by the DB Error Code() function?
      The DBErrorCode() function (not SQLCA.SQLCode) checks the results of Database access performed by a DataWindow. We check SQLCA.SQLCode after explicitly issuing embedded SQL statements, such as Commit.

27.     Which feature of the Data Window painter greatly simplifies the creation of a report having only one group?
      The easiest way to create a report that has a single group is to select the Group presentation style from the New Data Window dialog box.

28.     How would you define validation rules for the Data Window object?
      We can define validation rules in the Data Window painter. We can use the SetValidate() function in a script to set validation rules dynamically (at run time) in a script for DW.

29.     What is the difference between a Data Window control and object?
      Data Window control is a container for a DW object and is placed on the window. DW control has attribute and functions. Data Window object is a PB object which has connection to database and GUI. DW object has attributes. Data Window object represents the data source. It encapsulates your database access into a high level object that handles the retrieval and manipulation of data use for displaying data and capturing user input. Data Window object consist of :
data intelligence (perform test validation rules)
user interface (presentation style)
It is used to display data or capture user input. DW is an object that we use to retrieve, present and manipulate data from a relational DB or other data source in an intelligent way. (The DW control is the container for the DW object. The DW object is created using the DW painter; a DW control is placed on the window. A DW object has attributes. A DW control has attributes and functions. A DW object represents the data source. It encapsulates your database access into a high level object that handles the retrieval and manipulation of data. It is used for displaying data and capturing the user input. A DW object consists of data intelligence (performs test validation rules) and user interface (presentation style).

30.     What are the strongest points of using the DataWindow control?    
    Displaying data.
    Entering data.
    Scrolling.
    Reporting.