Kbase P66334: How to find a row and to reposition to it.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/17/2004 |
|
Status: Unverified
GOAL:
How to find a row and to reposition to it.
GOAL:
Finding a specific row and repositioning to it
FACT(s) (Environment):
Dynamics 2.1A
FIX:
findRowWhere
Finds a row and repositions to that row.
For a SmartBusinessObject (SBO), column names (comma separated); fieldname of a
table in the query in the form of TBL.FLDNM or DB.TBL.FLDNM (only if qualified with db),
For a SmartDataObjects (SDO), column names (comma separated); fieldname of a table in the query in the form of RowObject.FLDNM.
If the fieldname is not qualified, it checks the tables in the TABLES property and assumes the first is a match.
The operator (one for all columns):
? Blank?Defaults to (EQ).
? Slash?used to define an alternative string operator (EQ/BEGINS, etc.).
? A comma-separated list for each column/value.
Notes:
? This method resolves the row reposition on the server. As a result, the SDO can no longer determine whether the row position is invalid until after the request has been executed.
However, if the RebuildOnRepos property is set to TRUE, the Temp-table is emptied
before the request.
? The current behavior for a FIND that does not find anything when RebuildOnRepos is TRUE is to read the current batch again.
? The logic is in the query.p super procedure.