Kbase 20612: How to add a SmartSelect object to a SmartDataViewer and use it in an application
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
How to add a SmartSelect object to a SmartDataViewer and use it in an application
FACT(s) (Environment):
Progress 9.x
FIX:
The following example uses the Sports2000 database and assumes you want to add a salesrep combo-box on a customer SmartDataViewer. Follow these steps:
1) Create a SmartDataObject for a customer table with all the fields. Name it "dcust.w".
2) Create a SmartDataObject for a salesrep table with all the fields. Name it "dsalesrep.w".
3) Create a SmartDataViewer against dcust.w. Add the fields custnum, name and salesrep. Name the SmartDataViewer "vcustrep.w".
4) Add the SmartDataObject "dsalesrep.w" to the SmartDataViewer "vcustrep.w".
5) Locate the SmartDataField on the object palette, the rightmost icon in the second line from bottom.
6) Right click on it and choose "smartselect".
7) Move the mouse to the salesrep field on the "vcustrep.w" SmartDataViewer then release it.
8) Accept all the links that adviser suggests.
9) Create a new SmartWindow and add "dcust.w", "vcustrep.w", a navigation panel, and an update panel.
10) Run the SmartWindow.
Note that the salesrep field is displayed as a combo-box and it represents the values from the "salesrep" table.