Kbase P112656: ADM2: How to reposition an SDO to a record using its ROWID without reopening the query?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/16/2009 |
|
Status: Verified
GOAL:
ADM2: How to reposition a SmartDataObject ( SDO ) to a record using its ROWID without reopening the query?
GOAL:
Is there a way to reposition an SDO to a specific record given its ROWID without reopening the query?
FACT(s) (Environment):
Windows
Progress 9.x
OpenEdge 10.x
FIX:
Yes, use the 'fetchRowIdent' function. For example, the following code repositions the SDO to customer number 11. All child SDO's (if any) will be repositioned accordingly assuming links supporting that repositioning exist between these SDO's and the Customer SDO:
DEFINE VARIABLE pcRowIdent AS CHARACTER NO-UNDO.
FIND FIRST Customer WHERE Customer.CustNum = 11.
pcRowIdent = STRING(ROWID(Customer)).
DYNAMIC-FUNCTION('fetchRowIdent':U IN h_dcustomer, INPUT pcRowIdent, INPUT "").