Release 10.1A: OpenEdge Development:
ADM Reference

> ## findRowWhere

> Finds a row and repositions to that row.

> Location: sbo.p

> Parameters:

> `INPUT pcColumns AS CHARACTER`

> 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 uses the first match.

> `INPUT pcValues AS CHARACTER`

> Corresponding Values (CHR(1) separated).

> `INPUT pcOperators AS CHARACTER`

> 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.
> Returns: LOGICAL

> 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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095