PowerBuilder Interview Question and Answers
26. |
How would you define validation rules for the DataWindow object? |
|
We can define validation rules in the DataWindow painter. We can use the SetValidate() function in a script to set validation rules dynamically (at run time) in a script for DW. |
|
|
27. |
What is the difference between a DataWindow control and object? |
|
DataWindow control is a container for a DW object and is placed on the window. DW control has attribute and functions.
DataWindow object is a PB object which has connection to database and GUI.
DW object has attributes. DataWindow 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. DataWindow 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). |
|
|
28. |
What are the strongest points of using the DataWindow control? |
|
- Displaying data.
- Entering data.
- Scrolling.
- Reporting.
|
|
|
29. |
What is the difference between SQLCA.SQLCode and the value returned by the DBErrorCode() 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. |
|
|
30. |
Which feature of the DataWindow 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 DataWindow dialog box. |
|
|