Technical Information

Application Development Manual | Searching data files

Searching data files

Function

Find data in a data file.

Syntax

Detailed Description

The SEARCH function returns the record number for the first record in the specified data file for which the specified field matches the specified search string.

Fieldvalue specifies the field variable (specified by FIELD statement) of the target field.
Recordstart specifies the record at which to start. If this parameter is omitted, the BHT starts at record #1, the beginning of the file.

If there are no matches, the function returns 0.

Example

Search the following data file for 4901234567890 in the BARDATA$ field

private result%
private SNO$
private QTY$
private BARDATA$
open "TESTDATA.DAT" as #1                          ' open data file
field #1, 3 as SNO$, 5 as QTY$, 13 as BARDATA$     ' define fields
result% = search(#1, BARDATA$, "4901234567890", 1) ' search
print result%                                      ' displays 3
close #1

Contact us

QBdirect