PowerBuilder Interview Question and Answers

21. What Presentation Styles do you know and when do you use them?
  The Tabular presentation style presents data with the data columns going across the page and headers above each column. As many rows from the database will display at one time as can fit in the DataWindow object. We can reorganize the Tabular presentation style any way we want by moving columns and text. Tabular style is often used when we want to group data.

The Freeform style presents data with the data columns going down the page and labels next to each column. We can reorganize the default layout any way we want by moving columns and text. Freeform style is often used for data entry form.

The Grid style presents data in a row-and-column format with grid lines separating rows and columns. Everything we place in a grid DataWindow object must fit in one cell in the grid. We cannot move columns and headings around as we can in the Tabular and Freeform styles. But, unlike the others styles, users can reorder and resize columns with the mouse in a grid DataWindow object during execution.

The Label style presents data as labels. We choose this style to create mailing labels or other kinds of labels. If we choose the Label style, we are asked to specify the attributes for the label in the Specify Label Specification.

The N-Up style presents two or more rows of data next to each other. It is similar to the Label style. We can have information from several rows in the database across the page, but the information is not printed on labels. The N-Up presentational style is useful if we have periodic data; we can set it up so each period repeats in a row..

The Group presentation style provides an easy way to create grouped DW objects, where rows are divided into groups, each of which can have statistics calculated for it. It generates a tabular DW that has one group level and some other grouping properties defined. We can customise the DataWindow in the DataWindow painter workspace.

The Composite presentation style allows us to combine multiple DWs in the same object. It is handy if we want to print more than one DataWindow on a page.

The Graph presentation style creates a DataWindow object that is only a graph the underlying data is not displayed. As the data changes, the graph is automatically updated to reflect the new values. We use a graph to enhance the display of information in the DataWindow object such as a tabular or freeform DataWindow.

Crosstab processes all the data and presents the summary information that we have defined for it. We use if we want to analyse data. Crosstab analyses data in a spreadsheet. Instead of seeing a long series of rows and columns, users can look at a Crosstab that summarises the data.

OLE 2.0 presentation style using a process called uniform data transfer; info from PB supported data sources can be sent to an OLE 2.0 server application. The OLE 2-compliant application uses the PB supplied data to formulate a graph, map, a spreadsheet or the like to be displayed in the DW.

RichText presentation style using a RichText DW, you can create letters of other documents by merging info in your DB into a formatted DW. Master word processing oriented features such as headers, footers and multiple fonts are available in an easy-to-use format.
 
Your Name Your Email-ID
Your Answer
22. Describe the difference between the grid and tabular presentation styles.
  In the Grid presentation style, we cannot move columns and headings around as we can in the Tabular presentation style but in Grid presentation style users can reorder and resize columns with the mouse during execution.
 
Your Name Your Email-ID
Your Answer
23. Describe the difference between the labels and N-up presentation styles.
  In N-up style, we can also have information from several rows in the database across the page, but the information is not printed on labels.
 
Your Name Your Email-ID
Your Answer
24. How often must you set the Transaction object ?
  Just once when we define the DW control. If we change the association of a DataWindow object with a DataWindow control in a script, we must re-issue the SetTransObject () before the next retrieval or update.
 
Your Name Your Email-ID
Your Answer
25. What function changes the current row?
  SetRow()
 
Your Name Your Email-ID
Your Answer