INDEXSEEK( ) Function
| Visual FoxPro 9.0 SP2 |
| INDEXSEEK( ) Function |
| See Also |
|
Without moving the record pointer, searches an indexed table for the first occurrence of a record whose index key matches a specified expression.
INDEXSEEK(eExpression [, lMovePointer [, nWorkArea | cTableAlias [, nIndexNumber | cIDXIndexFileName | cTagName]]]) |
Parameters
- eExpression
-
Specifies the index key expression for which you want INDEXSEEK( ) to search.
- lMovePointer
-
Specifies if the record pointer is moved to the matching record. If lMovePointer is true (.T.) and a matching record exists, the record pointer is moved to the matching record. If lMovePointer is true (.T.) and a matching record doesn't exist, the record pointer isn't moved. If lMovePointer is false (.F.) or is omitted, the record pointer isn't moved even if a matching record exists.
- nWorkArea
-
Specifies the work area number of the table that is searched for the index key.
- cTableAlias
-
Specifies the alias of the table that is searched. If you omit nWorkArea and cTableAlias, the table in the currently selected work area is searched.
- nIndexNumber
-
Specifies the number of the index file or tag that is used to search for the index key. nIndexNumber refers to the index files as they are listed in USE or SET INDEX. Open .IDX files are numbered first in the order in which they appear in USE or SET INDEX. Tags in the structural .cdx file (if one exists) are then numbered in the order in which they were created. Finally, tags in any open independent .cdx files are numbered in the order in which they were created. For more information about index numbering, see SET ORDER.
- cIDXIndexFileName
-
Specifies an .idx file that is used to search for the index key.
- cTagName
-
Specifies a tag of a .cdx file that is used to search for the index key. The tag name can be from a structural .cdx file or any open independent .cdx file.
Note The .idx file takes precedence if duplicate .idx file and tag names exist.
Return Value
Remarks
See Also
© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic
Microsoft Visual FoxPro 9 SP2 Help file, VFPX Edition v1.08