Consultor Eletrônico



Kbase P60096: How to reposition a Browse to a ROWID
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   11/12/2004
Status: Verified

GOAL:

How to reposition a Browse to a ROWID

GOAL:

How to use the REPOSITION-TO-ROWID method

FACT(s) (Environment):

Progress 9.X
OpenEdge 10.x

FIX:

Use the REPOSITION-TO-ROWID method:

Moves a query object?s result list pointer to the row corresponding to the ROWID or ROWIDs you specify.
To reposition to a particular row when the query is a join, supply the ROWIDs of the buffers that correspond to the desired row.
Return type: LOGICAL
Applies to: Query object handle

The following example has been built against the sports database:
FIND FIRST customer WHERE cust-num = myVar NO-ERROR.
IF AVAILABLE(customer) THEN
QUERY BROWSE-1:REPOSITION-TO-ROWID(ROWID(customer)).
ELSE
MESSAGE "There is no cust-num = " myVar
VIEW-AS ALERT-BOX INFO BUTTONS OK.