Kbase P19377: How to build a relationship between a buffer and a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/19/2003 |
|
Status: Unverified
GOAL:
How to build a relationship between a buffer and a database table in a SmartDataObject?
FACT(s) (Environment):
Progress 9.1D
FIX:
1- From the AppBuilder's File => New menu, select to build a SmartDataObject.
2- Hit the "Define Temp-Tables" button on the second page of the SmartDataObject Wizard Screen.
3- Choose the "Add" button on the Temp-Table Maintenance Screen.
4- Select the desired database table from the Table Selector Dialog.
5- Back on the Temp-Table Maintenance Screen, switch one of the radio-set buttons under Properties from Temp-Table to Buffer.
6- Still on the Temp-Table Maintenance Screen, rename the buffer name (Table Name) to something different from the actual table name in the database.
7- Hit the "Ok" button to return to the SmartDataObject Wizard Screen.
8- Still on the second page of the SmartDataObject Wizard Screen, hit the "Define Query" button.
9- From the Query Builder Window, select the desired database table and hit the "Add >>" button so that the selected table moves from the selection-list on the left side to the selection-list on the right side.
10- Still on the Query Builder Screen, change the screen value of the Database combo-box from the connected database name to Temp-Tables.
11- Repeat step# 9 to move the created buffer from the selection-list on the left side to the selection-list on the right side.
12- Switch the radio-set button on the top of the Query Builder Window from Table to Join.
13- Turn on the Customize Join toggle-box and build the relationship between the created buffer and the actual database table.
14- Hit the "Ok" button to once more return to the SmartDataObject Wizard Screen.
15- Go to the next page on the SmartDataObject Wizard (page 3) and select the desired fields from the created buffer and from the chosen database table as well on the Multi-Field Selector Dialog by hitting the "Add fields" button on the Wizard's third page and the "Add" button on the Column Editor Screen.
16- Return all the way back to the SmartDataObject Wizard Screen, go to the next page (page 4) and finalize the SmartDataObject creation process.