| Home | Previous Lesson: Summary Next Lesson: Exercises |
Q: Is it possible to store data as part of the DataWindow syntax?
A: Yes, it is possible. You can insert either empty rows or data in the DataWindow from the Data view in the DataWindow painter by selecting View > Data menu option.
Q: What is 'Retrieve Only as Needed' option?
A: This option doesn't wait displaying the data to the user until it retrieves all the data, instead, it retrieves one screen full of data and displays to the user. When the user tries to scroll down the DataWindow, PowerBuilder brings the next set of data the is fits on the DataWindow's displays area.
Q: What are the restrictions on ' Retrieve Only as Needed' option?
A: This option has no affect for:
Q: What property allows you to resize the column height automatically depending on the data?
A: Setting AutoSizeHeight property (Height.AutoSize) does this magic for you.
Q: How Group presentation style is different from using GROUP BY clause as part of the SELECT statement?
A: Group presentation styles groups the data in the DataWindow by PowerBuilder (client) where as GROUP BY clause in the SELECT statement makes the database server to group the result set and send them to the client.
Q: What is the difference between 'Computed Column' and 'Computed Field'?
A: Computed Column is defined as part of the SELECT statement and is calculated by the database server where as Computed field is defined in one of the bands in the DataWindow and is calculated by PowerBuilder.
Q: What is the difference between assigning an edit style to a column in the Database painter and doing the same in the DataWindow painter?
A: Doing in the database painter will store those definitions in the extended attributes related PowerBuilder system tables in the database. This is taken as the default edit style for ALL new DataWindows you create after defining the edit style. If you define it in the DataWindow, that is stored as part of the DataWindow definition and is applicable to that specific DataWindow only. You can not even name that edit style in the DataWindow painter.
Q: What are the restrictions on the Crosstab presentation style?
A: There are several restrictions on the Crosstab presentation style DataWindow.
| Home | Previous Lesson: Summary Next Lesson: Exercises |