ph_finddata PowerHome formula function
Description
Finds data in a data retrieval area that was selected from an SQL Select.
Syntax
ph_finddata ( n, s, start, end )
| Argument |
Description |
|
n
|
The number of the data retrieval area (1 – 5)
|
|
s
|
A string whose value is a boolean expression that you want to use as the search criterion. The expression includes column names
|
|
start
|
A long identifying the row location at which to begin the search.
|
|
end
|
A long identifying the row location at which to end the search. To search backward, make end less than start
|
Return value
Long. Returns the number of the first row that meets the search criteria within the search range. Returns 0 if no rows are found and a negative number if an error occurs. If any argument's value is NULL, Find returns NULL.