Search for a single or subset of records matching a specific wildcard pattern.
OrdWildSeek( <cSkeletonExpr> ) --> lMatch
OrdWildSeek() -> nRecordThe function OrdWildSeek( <cSkeletonExpr> ) returns .T. (true) if one or more records matching the <cSkeletonExpr> could be found in the active index of the current work area.
The function OrdWildSeek() navigates to the next record of the current table matching the initial search condition. If no more records could be found the function OrdWildSeek() returns .F. (false) and navigates to the ghost record.
The function OrdWildSeek() can be used to efficiently determine subsets of a work area based on an index and search pattern. The function OrdWildSeek() uses the active index of the current work area for its search operation. A runtime error is raisen if the index is not of character type.
If the function OrdWildSeek( <cSkeletonExpr> ) return .T. it has succesfully found one or more matching records. Found() returns .T. (true) in that case, and the record pointer of the current workarea is positioned to the first matching record.
Subsequent calls of OrdWildSeek() without any parameter advance the record pointer to the next matching record and return .T. (true). If the last matching record is reached a call to OrdWildSeek() will return .F. (false) and the record pointer is positioned at the ghost record.
If the function OrdWildSeek( <cSkeletonExpr> ) does not find any matching record, it does not reposition the record pointer and returns .F. (false).
PROCEDURE Main
USE Customer
INDEX ON LASTNAME TO LAST.NTX
? OrdWildSeek("Wa*r?") // result: .T.
? "DbFound:",Found() // result: .T.
// result:
// Hit: 6 Key: Walter
// Hit: 22 Key: Waters
DO WHILE Found()
? "Hit:",RecNo(),"Key:",&(OrdKey())
OrdWildSeek()
ENDDO
CLOSE ALL
RETURN
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.