Kbase P17930: How can I display the current number for each row on a SmartDataBrowser
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How can I display the current number for each row on a SmartDataBrowser
FACT(s) (Environment):
Progress 9.1x
FIX:
The RowNum field in the RowObject TEMP-TABLE contains this information.
You only have to define a calculated field in the SmartDataBrowser displaying RowObject.RowNum. Beware that defining such a calculated field will not pass the AppBuilder syntax check, but it will work at run-time.
- Create a new SDB or open an existing one.
- Go to the Section Editor, and open the Definitions section.
- Add the definition for a new integer variable.
DEFINE VARIABLE iRowNum AS INTEGER.
- Close the Section Editor.
- Double click on the browser; the Property Sheet will pop up.
- Click on the Fields button; the Column Editor will appear.
- Click on the Calculate Field button; the Calculate Field Editor will appear.
- In the Expression field type:
RowObject.RowNum @ iRowNum
- Click on Ok. A syntax error message will appear:
** Unknown Field or Variable name - RowNum. (201)
in column 12.
- Just ignore the error message by clicking on Ok. You'll be back in the Column Editor.
- Close all open dialog boxes by clicking on the respective Ok buttons.
- Save; the SDB will compile cleanly even though it complained about a syntax error in the previous step.
- Test the SDB in your SmartWindow.