Kbase P32658: How to lookup related data in a SmartDataObject when the Sma
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/21/2003 |
|
Status: Unverified
GOAL:
How to lookup related data in a SmartDataObject when the SmartDataObject is embedded in the SmartDataViewer?
FACT(s) (Environment):
Progress 9.1x
FIX:
When you have a SmartDataViewer which contains a SmartDataObject that will be used to display related data on some read-only fields whenever the LEAVE event of a fill-in widget is fired, do the following:
1) Set the SmartDataObjects WHERE clause using the setQueryWhere function
2) Open the SmartDataObjects query using the openQuery function
3) Position to the first record of the SmartDataObject by using the fetchFirst method
4) Grab the needed values from the SmartDataObject using the columnStringValue function and display them on the SmartDataViewer by setting the SCREEN-VALUE of the widget(s) in which the data will be displayed